Cloud & SQLSailor

Cloud, Databases & Beyond!

Month: June 2010

June 16, 2010

How can we rename the logical file name of a data and log file

There are instances where in we need to rename the files and below simple Alter command will do that for you : ALTER DATABASE <Database> MODIFY FILE (NAME = <Current…
June 14, 2010

Talking about Adding BUILTIN\Administrators back to SQL Server

Quote Adding BUILTIN\Administrators back to SQL Server Recently I had to add BUILTIN\Administrators back to the server and here is what I had to do for the same. …
June 8, 2010

Script the permissions of an OBJECT

Recently I came across a situation where in I had to scripyt out the permissions of all the stored procedures for a database.After lot of R&D came across a SP…
June 4, 2010

Error :SQL Server 2005 cluster config and trying to move database to a different drive/create a database “Only formatted files on which the cluster resource of the server has a dependency can be used.Either the disk resource containing the file is not present in the cluster group or the cluster”

For the SQL Server resource we need to add a dependency of the drive to which we are moving the database and log files. 1. Right click the SQL…
June 3, 2010

Connection to target machine could not be made in a timely fashion

SQL Server configuration manager throws this error sometimes if we change start-up parameters for any instance and the solution is : Start > Run > type services.msc and press…