Blog Rat

cliconfg.exe can be found in two locations at a 64-bit system when sql client tools are installed: - [32-bit] C:\Windows\System32\cliconfg...

If you have execution permission error when you run your ASP.NET, assigning dbreader and dbwriter roles to the ASPNET user will not help, ...

GRANT EXECUTE ON SCHEMEA:: dbo TO ASPNET By default schema is owned by dbo (any member of the sysadmin fixed sever role), which is diffe...

The following applies to SQL 2005 Editions. Feature Express Developer or Enterprise Workgroup or Standard Is free? Ye...

In my part 1 , I mentioned to use VS.2008 to generate the data/schema script first and then import the data back to the database. Here is a...

SQL 2005 does not support DBCC REBUILD_LOG. Thus, you cannot use it to rebuild the LDF. Here is how I do to attach a database only using ...