Viewing 15 posts - 37,351 through 37,365 (of 39,941 total)
Save it as a text file, or perhaps grab it using the MS HTTP control in DTS.
Interesting idea, though.
Steve Jones
August 26, 2002 at 10:04 am
Why change these? Are they instances?
Steve Jones
August 26, 2002 at 9:28 am
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
Viewing 15 posts - 37,351 through 37,365 (of 39,941 total)