Siusic - siusic.com
General Information:
Latest News:
Master.mdf is Compressed But Does not Reside in a Read-only Database or Filegroup. The File Must be Decompressed. 6 Aug 2009 | 08:31 pm
I have not used the developer edition of SQL server on my laptop machine for a long while. When I try to turned on SQL server today I found it couldn’t start. When I check the event log there was an e...
SQLCmd Example to Output in CSV Format 6 Aug 2009 | 06:19 am
SQLCmd is a very handy tool used to execute SQL script automatically and output results to a file. Here is an example: sqlcmd -S “ServerName” -U “UID” -P “PWD” -d “DBName” -i “c:\input.txt” -o “c:\ou...
An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode 26 Jul 2009 | 10:41 pm
I was trying out IIS7 the other day. When I was trying to set up a new site I got the following error message. Error Summary HTTP Error 500.24 - Internal Server Error An ASP.NET setting has been de...
Can Not Connect to SQL Server Named Instance Remotely? 18 Apr 2009 | 09:18 am
The other day I was told to install SQL Server 2000 on to a server that was already running SQL Server 2005. The 2005 version SQL server was running as the default instance on the server. So obviously...
The Best Way to Grant Execution Right on xp_cmdshell and Cross Database Ownership Chaining 11 Apr 2009 | 11:58 am
The best way to grant user who is not a member of sysadmin the right to execute xp_cmdshell system store proc is to have xp_cmdshell wrapped into a user store procedure so that users can do just the t...
