Viewing 15 posts - 38,356 through 38,370 (of 39,720 total)
You can create the table in SQL 2000 as well, but you will have issues if the data exceeds the size.
Steve Jones
February 5, 2002 at 11:32 am
Sorry, haven't seen it.
Do you really need the NOLOCK? Are there that many locks being held?
Steve Jones
February 5, 2002 at 11:31 am
Are you sure that the updates should change the values in the table? Also, this will only work for single row updates. You might have strange issues if more than...
February 5, 2002 at 11:28 am
Be sure you are not connected to the server in that database. If so, you will not be able to drop the db because you have a "shared lock" on...
February 5, 2002 at 11:25 am
February 5, 2002 at 11:12 am
February 5, 2002 at 11:11 am
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
Viewing 15 posts - 38,356 through 38,370 (of 39,720 total)