Viewing 15 posts - 38,131 through 38,145 (of 39,489 total)
February 4, 2002 at 4:41 pm
Master contains all the server wide definitions for the new server. Unless the new server is physically exactly like the old one, I'd avoid this. The only reason to do...
February 4, 2002 at 4:37 pm
February 4, 2002 at 3:14 pm
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
February 4, 2002 at 3:13 pm
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...
February 4, 2002 at 3:10 pm
I tried this with a CHAR column and it still is a PK violation. Apparently there is no difference.
Steve Jones
February 4, 2002 at 3:08 pm
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
February 4, 2002 at 3:01 pm
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...
February 4, 2002 at 2:59 pm
Haven't tried it. Doubt it would work. Only work with user dbs. Try to stay away from system dbs.
Steve Jones
February 4, 2002 at 2:30 pm
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
February 4, 2002 at 11:29 am
Your welcome. It'd be interesting to see how it goes. Let us know what works and what doesn't.
Steve Jones
February 4, 2002 at 11:28 am
February 4, 2002 at 11:26 am
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...
February 4, 2002 at 11:17 am
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...
February 4, 2002 at 11:15 am
February 4, 2002 at 11:12 am
Viewing 15 posts - 38,131 through 38,145 (of 39,489 total)