Never tried. An interesting question. I will defer to Brian Kelley, he seems to be the profiler guru. Hopefully he will hit this tonight.

Steve Jones

steve@dkranch.net

In the Professional DTS book, Brian Knight talks about this. He has some experience, but he's having a baby (well not him, his wife) today, so he might not get...

I tried this with a CHAR column and it still is a PK violation. Apparently there is no difference.

Steve Jones

steve@dkranch.net

you can try here:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_0rab.asp

but the best way is to save your DTS package as a VB file. In v7.0, I think this was an add-in. It's native in 2000.

Steve Jones

steve@dkranch.net

Do a global search and replace in ASP or a search and recompile in SQL to add the brackets. No impact on the server. Just tells the parser not to...

Haven't tried it. Doubt it would work. Only work with user dbs. Try to stay away from system dbs.

Steve Jones

steve@dkranch.net

You can look at my PushFTP article for sample text file creation. Also here's the ref from MS:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vtoriobjects.asp

Steve Jones

steve@dkranch.net

Your welcome. It'd be interesting to see how it goes. Let us know what works and what doesn't.

Steve Jones

steve@dkranch.net

Don't forget about your backups and how you manage them.

Steve Jones

steve@dkranch.net

I'd write a process to look for open transactions. If you find one, you can kill the conneciton and let the dba know. dbcc opentran will identify opn transactions. Of...

When you post, pls also let us know the physical as well as logical setup of the sever. Better yet, write it up as an article and send it to...

Someone go to TechEd and let us know!!!!

Steve Jones

steve@dkranch.net

That's funny.

I use EM everyday. I'm not trying to boot the tool, but it shouldn't, IMHO, be THE tool for scripting changes for your db. The biggest...

You are welcome. This one stumped me for quite awhile.

Steve Jones

steve@dkranch.net

My vote is to push what you can to the clients AS LONG AS IT DOES NOT substantially imopact the perceived performance of the client. You can upgrade the db...