Best thing is to get them to answer your question and try to get them to demo it to you on 2000. Most companies will do this as they want...

First off in your current query I don't see the rela need to even have the GROUP BY since this is grouping all fiedls, dropping the group by and using...

Mater of preference, education history (which they learned first), typing shorter in many cases, and of course since it is the prescribed method to use on a unicode data.

When you say an incremental counter on a gfroup by and clearing after each, exactly what is the expected result? I am a little confused by your wording and an...

I believe the subscriber has to also run under a domain account for the two way to occurr. I usually set all my SQL Servers to use the same domain...

I agree with Steve, there is something causing it. What is your code doing since INSERT and UPDATE triggers do not get fired but by those events alone. It is...

Simons on trakc but I believe you need to add EXEC before xp_cmdshell or it will assume they are the same piece and may give an error.

exec sp_msforeachtable 'EXEC xp_cmdshell...

Have not seen anyone post a statement on the net about it as infected. However, I would test with 1 or 3 AntiVirus apps and setup a machine with a...

See this thread as may be related.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8392&FORUM_ID=24&CAT_ID=1&Topic_Title=Veritas+Backup+Exec+8%2E6+and+SQL+Server&Forum_Title=Backups

The only thing you may have trouble with is sysdepends will not pick up dynamic SQL and it will not tell you how referenced. There is a script on this...

Or

REPLICATE('0', 5-LEN(field_name)) + field_name

Yes, just because a board supports 2 CPU doesn't mean you have to license for 2 if you only have 1 installed. But you might want to check to see...

Depends, I generally use DTS but sometimes I have situations where a quick openquewry does great. If doing on a regular basis you need to determine first how often and...

I use Truncate Table WorkSheetName not sure if DROP TABLE will work and if you just want to repopulate see no reason to try.

I don't have my server here now,...

Consider, when you run it in a cmd prompt yourself, it is using your own security context to make the remote connection. When you run it thru SQL Server it...