Forgot to add to last post...  You need to add BinaryData to columns that you are capturing for the plans to be saved....

How bout

DECLARE @Text VARCHAR(255)

DECLARE @VAR1 VARCHAR(50)

DECLARE @VAR2 VARCHAR(50)

DECLARE @VAR3 VARCHAR(50)

DECLARE @Dlm1 INTEGER

DECLARE @Dlm2 INTEGER

DECLARE @Diff INTEGER

DECLARE @3Col BIT

SET @Text = 'San Francisco, CA'

SET @Dlm1 = (SELECT CHARINDEX(',', @Text))

SET @Dlm2 =...

1.  Is the machine you are attempting to install SQL to on the network? or is it still just a part of a workgroup?

2.  Is SQLService a DOMAIN account or...

SQL 2K and older does not support SELECT TOP @Number type syntax.  This is a new feature with SQL 2K5.

If you need to return a dynamic TOP n unfortunately, you...

When you suspect the problem is occurring I would start SQL Profiler and capture traces that you can review.

Show Plan All, Execution Plan, possibly Show Plan text (all under Performance),...

Try adding the same connection to MySQL under the DTSUser account in ODBC connections (Can be found in Control Panel under Admin. Tasks).  This should allow you to add the...

Have you tried encapsulating the AS in [] or '' i.e. [Client_Name] or 'Client_Name'?

The script that EM generates is either a SINGLE text file or MULTIPLE text files.  You can import these into Excel and then annotate to your hearts content...

I think SpeedFerret or some other 3rd party tool MIGHT be able to do that IF your DTS packages are saved as files.

IF your DTS packages are saved in MSDB...

A single stored-procedure can be called inherently multiple times concurrently.  However, depending on what the procedure is doing it may block itself.  i.e. trying to insert the same record in...

Why not use EM to produce a SCRIPT of ALL objects??  Granted you need to do this PER database but this can be done using sp_MSForEachDB to assist with the...

#1  PATINDEX may give better performance because it is optimized for MS SQL and not just generically created SQL 92 statement LIKE.  (Probably wrong on this ....)

#2 > is a...

You cannot remove anyone from Public.  The only thing you can do is assign to denywrite and/or denyread....

I tend to agree with David.  We are currently working on an archiving strategy that will provide same reports as "live" system for last fiscal year.  This way at max...

Can you please provide what version of SQL you are using ?  i.e. SQL 7 or 2K?

There is a problem with SQL 7 where an active or "stuck" transaction could...