SQL Server Tools

I have tried to script all of stored procedures in one database on SQL server 2005 then it seems like get stacked. To script one stored procedure has no problem however when try to script all stored procedures SSMS never respond. ...

December 7th, 2006 Company: myLittleTools Contact: Elian Chrebor Paris, France myLittleTools is very proud to announce myLittleBackup for SQL Server 2000 and 2005. myLittleBackup for SQL Server 2000 and 2005 is the first Backup/Restore solution specially designed for shared SQL Server hosting. With ...

Hi All, Just thougt I'd post this here, I saw some people with this problem, but no solution. I had a problem in SQL server 2005 where any SSIS tasks submitted (maintenance plan, copy database) gave me this error: ...

Hi all: I have MSCRM running in a VPC setup, so since I had 4 backup copies of the VHD files, I never backed up the DBs themselves. Now for some reason all of the images have an error in the MSCRM Metabase database, and I cannot ...

I am having a problem copying a database on a server back to the same server from a remote computer using SSMS. I have 2 remote computers (WinXP) running SSMS on the same domain as the server. I log in as an administrative user on ...

On a "day to day" basis, the account I use to do work is not a member of the Local Administrators group. When I do an install, I'll either do a Run As or log on as a Local Administrator account to do the install. ...

I'm troubleshooting some performance issues, but need to know a few of the finer things that I haven't been able to find on the Net yet.  Currently I'm trying to find out how close things are in Management Studio compared to a ...

Hi, In SQL2000 I had to change permissions to scmanager to tell if SQL2000 was running on a server after the server was upgraded to W2K3 SP1. This was due to SP1 security changes. Now I have SQL2005 Management Studio and I cannot see the status of any of ...

We have a 2 node Sql 2000 cluster running on Legato Cluster. We are planning to move it to MSCS 2 node Active/Passive Cluster. I am trying to migrate to have less downtime which allows me to backout if any ...

If SQL text is copied from MS-word into SQL Server Management Studio, invisible missing linefeeds may be copied in. This results in syntax error messages or commands skipped. Very dangerous feature. If the following example is executed the middle print statement is not ...

I'm trying to restore a database that was backed up on another computer. The command I used was: RESTORE DATABASE iDB    FROM DISK = 'f:\xxxxx\sqlbackup' The error I get is: Server: Msg 3101, Level 16, State 1, Line 1 ...