Hello,

Are all the records in the file 4000 characters long or is there one, or more, records that are only 3640 characters long?

Regards,

John Marsh

Hello,

What results do you get if the Where clause uses the following syntax:-

WHERE @TagSelected = t.[TagTitle]

And you call the SP as follows:-

Exec GetProductsByTagTable @TagSelected = N'????'

What Data-Type is the column...

Hello,

Did you already take a look at this MS Page on DW Design Best Practices:

http://msdn.microsoft.com/en-us/isv/bb190492.aspx

Regards,

John Marsh

Hello again,

I still guess at a permissions issue. If you run SQL Agent under your Domain Account, does the Maintenance Job fail?

Regards,

John Marsh

Hello again,

Did you follow the steps in the article for producing more detailed error information e.g. logging to a file?

Without any more information it will be hard to resolve this...

Hello,

Have you considered using sp_msforeachdb as an alternative solution?

Regards,

John Marsh

Hello,

Please see the following Article on how to troubleshoot Deadlocks:

http://blogs.msdn.com/bartd/archive/2006/09/09/747119.aspx

Regards,

John Marsh

Hello,

Please see the following MS Article on how to troubleshoot Maintenance Plans:

http://support.microsoft.com/kb/288577

Regards,

John Marsh

Hello again,

From BOL it seems you can only use Included columns in a Create Index statement i.e. not in an Add Constraint statement.

Regards,

John Marsh

Hello,

I am not 100 percent sure what you want to do. Could you possibly list the indexes and constraints that you currently have (fields, index/constraint-type, clustered or not) and then...

Hello,

In SQL 2000, it is possible to disallow Page Level locks for an Index. Please see the BOL Topic “Customizing Locking for an Index”.

Regards,

John Marsh

Hello,

If you are using a specific set of credentials to access a Linked Server then the password that you use must be the one that exists on the remote server....

Hello,

I use RedGate’s SQL Compare to check for differences between two DBs. It isn’t free, but it does also include a nice synchronisation function for the price.

Regards,

John Marsh

PS: Alternatively you...

Hello again,

Thanks for the update. Glad to hear that it is working now.

Best regards,

John Marsh

Hello,

Scalar UDFs (user defined functions) can be inefficient (Please see this article: http://sqlblogcasts.com/blogs/simons/archive/2008/11/03/TSQL-Scalar-functions-are-evil-.aspx)

You would probably be better off creating a look-up table and joining to this in your...