Do you need to support SQL Logins or do all users authenticate using either their NT credentials or that of an IIS service account?  If so, you should put the...

What versions of MDAC are the XP and Win2000 clients running?

I know this may be an oversimplified suggestion, but are they really using all 4000 CHARS?  I experienced a similar problem recently.  After doing a...

Without sounding cliché, PLEASE DON’T TRY THIS AT HOME!

You could, but I wouldn’t recommend, stopping...

There are ways, but there is NO WAY of doing this while still ensuring transactional consistency of your data file(s).  I would contact Microsoft PSS before attempting...

DELETE MyTable

WHERE MyID NOT IN (

  SELECT MAX (MyID)

  FROM MyTable

  GROUP BY SSN)   --assuming MyID and SSN cannot be null

Keep in mind this will delete the oldest record, and...

Razvan,

I had forgotten about the restriction on aggregate functions in INDEXED VIEWS. So following the natural progression, perhaps a Rowset UDF instead? The query plan would then be precompiled...

What OS versions are on both servers?

I would suggest that you do an inventory of any INDEXED VIEWS that you have on your existing Enterprise Edition install. Make sure that your implementation code is specifically...

try writing your sub-select statements as indexed views, then join to the indexed views.

Let me preface this by saying that generally it is bad practice to allow the client code to determine the CustomerID. This is precisely why SQL Server (and every...

first off, try running:

exec xp_sqlagent_proxy_account 'GET'

just to make sure that the Proxy Account is set up correctly.

also, how is the user running xp_cmdshell? through Query Analyzer? how...

have you considered Application Roles?