Viewing 15 posts - 37,231 through 37,245 (of 39,818 total)
I had this as well. I'm sure you can clean out the registry and get a default, but I didn't bother.
No difference for a named instance. Just have the name...
August 23, 2002 at 1:43 pm
I had this as well. I'm sure you can clean out the registry and get a default, but I didn't bother.
No difference for a named instance. Just have the name...
August 23, 2002 at 1:20 pm
http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp
http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp - Need to update this
Steve Jones
August 23, 2002 at 10:46 am
The XML usually comes back as a single result set or a stream. You have to work with it differently.
ADO has a method to convert it. Check the 4guysfromrolla.com or...
August 23, 2002 at 10:43 am
I'd be very careful here. HSM has matured, but I used to use it in an imaging solution and it was sssssllloooowwwww at times looking for old images. Not sure...
August 23, 2002 at 10:41 am
Glad it worked. I think this took me awhile to get working on one server, but was flawless on another. I don't use the debugger often, but it seems to...
August 23, 2002 at 10:37 am
I had a copy at my last job. Pretty good, well written. Don't remember anything earthshattering in the book, but a good reference to keep handy while trying to figure...
August 23, 2002 at 10:34 am
Unless you had profiler running, there isn't. QA shows the time in the lower right corner. You can also use select getdate()s bracketed around your queries and output this to...
August 23, 2002 at 10:25 am
Could probably build somethng, but no way I know of. Profiler would capture the info and then you could print the result set from the file or table.
Steve Jones
August 23, 2002 at 10:13 am
You can do this with WMI. I started down this path and it was annoyingly complex. No good object model.
I may take another look. Testing Patrol right now and...
August 23, 2002 at 10:08 am
don't know the answer, but I wouldn't be surprised if there is a buffer limit. Some funny size limits seem to occur in passing data or returning it at times.
I'd...
August 23, 2002 at 10:02 am
Thanks. I suspected as much. We've seen some other similar issues since then.
The linked server is an AS/400 with millions of rows, so I'm not surprised the linked server is...
August 23, 2002 at 10:00 am
You can if you stop SQL Server. The other alternative is run perform a SQL Backup to a flat file (usually a .bak file) and backup this.
Steve Jones
August 22, 2002 at 3:35 pm
I completely agree with Jay, but I too, like line numbers.
I usually edit stuff in EditPlus and like the line numbers. I wish QA would give them to me, even...
August 22, 2002 at 3:30 pm
what do you mean? run a filesytem .sql file from T-SQL? You can do this with isql and using xp_cmdshell.
Steve Jones
August 22, 2002 at 2:05 pm
Viewing 15 posts - 37,231 through 37,245 (of 39,818 total)