It's a reserved word (ODBC). EM adds the brackets for you I think.

Andy

Maybe double check the MDAC, I currently use 2.6.

Andy

Have you updated your statistics since upgrading to SQL2K? Is the user running the same package that you're running at night? Have you profiled to see what is using most...

Are you connecting as SA?

Andy

Also have to look at fixing it moving forward. If you have a user(s) that you want to be able to create tables, I usually alias them as DBO. On...

Totally agree about auto shrink. Better to use the maint plan to do this once a week if it's important.

Andy

I think you have to assess the real value of a document. One of the things I've picked up from XP/Agile Modeling is that documentation has a cost, you can...

Thats a very good list. Only thing I have to add is that using a maintenance plan on your server will take care of a large number of these items...

Changing passwords shouldnt affect your connectivity. Start with pinging from client to server. If that fails switch to tracert to see where it's failing. Probably worthwhile to consult with your...

Honestly I think Books Online is the best bet for this stuff, since its the syntax you need. If you are working without SQL at the moment, http://www.msdn.microsoft.com has everything...

Then you'll have to build the sql on the client.

Andy

I'll agree its not obvious that you can't do what you suggest, after all its done so easily in VB/ASP/etc. Still, thats the rules for now!

Im the DBA, but I...

What's wrong with modifying it? I have the unusual situation of having more than 200 db's that all have to have one proc modified when the db is created. I...

Overall the 2nd solution is better...IF..you can drop the indexes. Not always possible in production. Faster is better, I would guess (have not measured) that it would use less disk...

I think thats correct - it's restores put replication is not set up entirely.

Andy