Monthly Archives: April 2007

Cannot Access CD-ROM and “Code 31” Error Message in Device Manager After You Remove Adaptec Easy CD Creator from Your Computer http://support.microsoft.com/kb/270008

Printers That Use Ports That Do Not Begin With COM, LPT, or USB Are Not Redirected in a Remote Desktop or Terminal Services Session http://support.microsoft.com/kb/302361

  declare @strSQL nvarchar(2000) declare @cnt int SET @strSQL = ‘SELECT @cnt = count(*) FROM table1 WHERE field1 = 1’ Exec sp_sqlexec @strSQL, N’@cnt int ouput’, @cnt out select @cnt as TestCount or declare @strSQL varchar(500) , @cnt int create … Continued

  To rename the logical file name of the pubs data file to pubs_data. ALTER DATABASE pubs MODIFY FILE (NAME = pubs, NEWNAME = pubs_data)