The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New A tape device is not detected by SQL Server Management Studio in SQL Server 2005 or by SQL Server Enterprise Manager...

You can use one of the following to know the structure of a table 1 Generate SQL Script option from Enterprise Manager/Management Studio 2 select * from information_schema.columns where table_name='table_name' 3 EXEC sp_help 'table_name' 4 EXEC sp_columns 'table_name' 5 In Query...

As you may be aware you can take help of Registry settings in order to copy the SQL Server list that are managed from the Central Managed server. I have seen this VBScript posted by Mohammed U posted the following script, you can save it as .VBS that works only for window logins. '* Author: Mark...

One of the Developer complained that he is unable to create one file per object using Generating SQL Scripts within Management Studio. It is one of the good feature within SQL Server 2000 using Enterprise Manager where you can differentiate the objects per file, and it is still available within SQL Server...

It was long time ago I have used FULL-TEXT within our environment, recently I have been given a task to manage a full text SQL instance. Well to refresh my tasks I have installed Full Text Search component on Windows 2003 Server for SQL server 2000 instance. I've ensured to install relevant FULLTEXT...