How to connect to SQL Server 2005 database through Ruby
- by Praveen
How to connect to SQL Server 2005 database through Ruby in Windows
Search Results
Search found 19515 results on 781 pages for 'visual studio 2005'.
Page 6/781 | < Previous Page | 2 3 4 5 6 7 8 9 10 11 12 13 | Next Page >
-
-
How do you create SQL Server 2005 stored procedure templates in SQL Server 2005 Management Studio?
- by Chris Woodruff
How do you create SQL Server 2005 stored procedure templates in SQL Server 2005 Management Studio?Read the article
-
COM+ Connection Pooling Doesn't Appear to be working on SQL Server 2005 Cluster
- by kmacmahon
We have a COM+ Data Layer that utilized Connection Pooling. Its deployed to 3 clusters, 2 SQL Server 2000 and 1 SQL Server 2005 environment. We noticed today that our monitoring software is reporting Thousands of Logins per minute on the SQL Server 2005 box. I did some tracing in both environments and profiler is reporting this for the 2000…Read the article
-
Where is Visual Studio 2005 Express at?
- by Spoike
I'm working on a project that requires Visual Studio 2005 and I've been trying to find a legitimate download site for Visual Studio 2005 Express, but it seems like Microsoft only wants people to download the 2008 version instead. Anyone knows why it's like this and if there is some link somewhere where Visual Studio 2005 Express is available?Read the article
-
Sql compression and backing up in sql server 2005
- by cagin
Hi there I want to backup my database with compression. This is my code : BACKUP DATABASE dbbbb TO DISK = N'C:\\dbbb.bak' WITH COMPRESSION this running correctly in Sql Server 2008. But my server has Sql Server 2005 and COMPRESSION is not a recognized BACKUP option in 2005. How can i compress my backup in 2005 Thank you for your helps.Read the article
-
SQL Server 2005, Sudden increase of connections - SharePoint 2007
- by CrazyNick
We observed that sudden increase of SQL connections during a specific hour, it is a backend of a SharePoint 2007 Farm. From SharePoint 2007 Perspective: 1. Incremental crawling is scheduled at that time and few of the Timer jobs (normal timer jobs) are scheduled to run every mins / per 10mins. 2. Number of user requests are less. From SQL…Read the article
-
SQL Server 2005, Sudden increase of connections - SharePoint 2007
- by CrazyNick
We observed that sudden increase of SQL connections during a specific hour, it is a backend of a SharePoint 2007 Farm. From SharePoint 2007 Perspective: 1. Incremental crawling is scheduled at that time and few of the Timer jobs (normal timer jobs) are scheduled to run every mins / per 10mins. 2. Number of user requests are less. From SQL…Read the article
-
SQL Server 2005 jobs running twice in a row - using LiteSpeed
- by Malnizzle
Howdy! I have a SQL server (2005) backing up to a network share, who has a group of maintenance plans setup through LiteSpeed to backup different DBs. They were just set up to run two sub plans on different schedules for full/diff backups and did that just fine for a couple of months. Then I added "Clean Up" task to the subplans. Ever…Read the article
-
SQL Server 2005 Reporting Services - Configuration Manager & Management Studio Problems
- by Nick
When I open Reporting Services Configuration Manager on my server, an error message appears that says: Reporting Services Configuration Manager An unknown error has occurred in the WMI Provider. Error Code 800706B3 This error appears before I can even attempt to connect to an SSRS instance. In addition to this problem, I'm not able to…Read the article
-
Best way to replicate / mirror 100s of databases in SQL 2005
- by mrwayne
Hi, I currently host around 400-500 SQL 2005 databases of varying sizes (1-10 gig) each. I am aware of most of the different methods available and the general pros/cons of mirroring, log shipping, replication and clustering, but i am not aware of how well they tend to perform when its employed at the size i have specified (400-500…Read the article
-
ms sql 2005 server role problem
- by Brandon
On one of our sql 2005 servers we are no longer able to give any users server roles (ex. sysadmin). It appears to be successful both through the UI and through code. But when we check in the db and in the UI the role is unchecked and not shown for the user in the master db. Permissions don't seem to be the issue as we are testing…Read the article
-
SQL Server Express 2005 cannot connect
- by jp
hi all, I have a SQL Server Express 2005 install on a godaddy virtual terminal which currently is only connected to(locally with mgt studio) every few days or so. Every time i try to connect I get a cannot connect to SQL Server error and after a restart it I can connect just fine locally. I was wondering if there is a timeout…Read the article
-
MOM 2005 SP1 and MBSA 2.1 : Compatible?
- by Mitch
We're currently using MOM 2005 SP1 for our system monitoring duties. It was installed and "configured" by someone who is no longer on our team. In the process of correcting a persistent error in the applications log of all of the monitored servers, "Default Global Virtual Directory Not Configured", I'm seeing the MBSA…Read the article
-
Where to set permissions to all server for logon trigger on sql server 2005
- by Jay
I need to keep track of the last login time for each user in our SQL Server 2005 database. I created a trigger like this: CREATE TRIGGER LogonTimeStamp ON ALL SERVER FOR LOGON AS BEGIN IF EXISTS (SELECT * FROM miscdb..user_last_login WHERE user_id = SYSTEM_USER) UPDATE miscdb..user_last_login SET last_login =…Read the article
-
Visual Studio 2005 Open Project Dialog Slow as Molasses
- by futureelite7
Whenever I try to open a project in Visual Studio 2005 (Windows XP), my open project dialog become slow as molasses - navigating down one level of folders typically takes almost 60 seconds. Finding the project and opening it can take up 4-5 minutes, which is just ridiculous. I've checked the open project dialogs of…Read the article
-
SQL 2005 Log Shipping - Was working, now isnt!
- by Jim
Hello, I had log shipping working between two SQL 2005 server fine. I suspect that a job was added to the source server which backed up the transaction log to disk (nothing to do with the existing log shipping job). As I understand it, if you do this then log shipping will fail to work. Sure enough, it no longer…Read the article
-
SQL Server 2005 SP3 Express Backups Incredibly Slow
- by Adam Robinson
I'm attempting to troubleshoot an issue with one of our customers who's using SQL Server 2005 SP3 Express to house their application data. The automatic backups that we perform when upgrading our application are timing out after 30 minutes, and I've been sitting and watching the backup take place in SSMS for about…Read the article
-
SSRS 2005 report manager link not coming up
- by Mohammed Moinudheen
On my SQL Server 2005 installation. I am able to view the report server URL but I am unable to logon to the report manager URL. "http://servername/reports" I don't get any error message at all. Only thing is the page never loads and is in a hanged state. From the reporting services log folder, I am unable to see…Read the article
-
Visual Studio 2005 SP1 refuses to install in Windows 7
- by JesperE
I'm trying to install Visual Studio 2005 in Windows 7. When attempting to start, Windows 7 complains that VS2005 is incompatible with Windows 7 and offers me to search online for a solution. It comes up with a link to VS2005 SP1 for Vista and Windows 7, but when I download it (VS80sp1-KB932232-X86-ENU.exe) and try…Read the article
-
SQL Server 2005: Rename DB Server Instance Name?
- by Code Sherpa
Hi, Can somebody tell me how to rename the DB server instance name and a DB name in SQL Server 2005? Right Now I Have SERVER/OLDNAME -- oldnameDB I want to change the server instance and also change the db name. I have tried: EXEC sp_renamedb 'oldName', 'newName' and that has changed the dbname as it…Read the article
-
Virtual Server 2005 R2 kungfu
- by AngryHacker
Does Virtual Server 2005 R2 have a command line interface, that's versatile enough? Here is a situation. I run a Win2k VM on an old memory constrained machine. I allocate it 378MB of RAM and the VM runs just fine. Once a month, inside the VM, I backup the (a very large) database, compress it using 7Zip and…Read the article
-
-ssadd is invalid when setting up Sessions on SQL Server 2005
- by P.Brian.Mackey
I have a dev and QA environment with SQL 2005 EE on dev and SQL 2000 on QA. On QA I run aspnet_regsql –ssadd –sstype t -E in command line and it works fine. I run the same command on dev and it returns "'-ssadd' is invalid". The working directory for both is C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727. …Read the article
-
Error when I try to connect to a SQL Server 2005 from the internet
- by Manish
My SQL Server is on a local machine. I want to access it through internet. I created a website through I want to connect local SQL Server 2005. This is the error message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or…Read the article
-
Connecting SQL 2005 to Oracle 10g
- by Lorn
Environment: - Oracle 10g database over a windows 32bit 2003 server - SQL 2005 database over a windows 32 bit 2003 server. I am trying to connect the above databases through heterogeneous services. I have updated the following files: TNSNames.ora, Listener.ora and hs.ora. When performing a test connection…Read the article
-
Visual Studio hangs when deploying a cube
- by Richie
Hello All, I'm having an issue with an Analysis Services project in Visual Studio 2005. My project always builds but only occasionally deploys. No errors are reported and VS just hangs. This is my first Analysis Services project so I am hoping that there is something obvious that I am just missing. Here…Read the article
