It is OK for them to have extra 14 bytes for overhead. It is still much better then our Oracle admin told me when I asked him to create a...

I know that. The question asked how many we must create (and run), not how many you will be able to open in a Maintenance Plan Designer after you finish....

Aaron,

you may be right about the tasks executing at once INSIDE one plan created exclusively in SSMS. I was not able to add the precedence constraints when opening One plan...

Jason,

CREATE FULLTEXT CATALOG (Transact-SQL)

CREATE FULLTEXT INDEX (Transact-SQL)

articles in SQL Server Books Online (BOL)  have  3-line examples on how to create a full-text catalog and create an...

Hi,

Do you have permissions? At the very least you have to have an NTFS permission to create a file for the log I would guess.

I would say it is an instance of Connection object with a certain Process ID (SPID) and all objects instaces for queries, actions, results etc. that have this particular SPID as...

Papillon,

When you install and click Advanced Button on the Components to Install and go to the Installation Selection Screen and expand Client Components do you see that all features (subcomponents)...

Jose,

It was just an example.

I tested creating a report with Wizard and used a user who has a password that ends with ! It worked, but I had to...

I did not answer yet because I don't know what is asked. At a very minimum I must use 1 plan with 1 backup database task which could be edited...

Hi,

Tell us what would you like to do:

- To Install Client Tools like Management Studio and more you need to start the installation and on the installation selection screen...

Did not we have a question QOD yesterday what is the comment sign in XML? The answer was <!--   -->  maybe the web page does not like the ! mark?

I always get this message in 2000 when I do a restore and add the file but don't pay attention that in the device list there is already one present...

in SQL Server I would populate a temp table with the additional identity field. I think in MS ACCESS you can create a query over your data and use Autonumber field.

In SQL 2005 it is is exactly the same as in SQL Server 2000: right-click on the database, All Tasks ->Import Data (or Export Data) It brings up the wizard....

Hi,

In SQL Server 2000 Start Menu there is an entry Configure SQL XML Support for IIS. It brings up IIS Virtual Directory Management for SQL Server which is sort of...