Viewing 15 posts - 38,386 through 38,400 (of 39,754 total)
Not sure I follow either. .NET is based on a submision to a standards body. Granted it's originated by MS, but it will be crafted to a standard (we hope)....
February 5, 2002 at 3:27 pm
February 5, 2002 at 3:06 pm
This will cause problems. Why not use a stored procedure to do the set, insert and unset all at once?
Steve Jones
February 5, 2002 at 1:44 pm
I need to give it a try, but with my version control system and only a few dbs, I don't have any issues. Also the short release cycle (< 4...
February 5, 2002 at 11:33 am
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
Viewing 15 posts - 38,386 through 38,400 (of 39,754 total)