Viewing 15 posts - 37,306 through 37,320 (of 39,902 total)
Agree with Antares. Query should have done something, but what happened.
Are you sure the query was correct? There was data to return. Perhaps you check the "check query" button and...
August 28, 2002 at 10:12 am
Can't use a text datatype as an output parameter. Return it as a result set.
Steve Jones
August 27, 2002 at 10:45 am
There are threads. Two differnt philosphies.
1. Build dynamic sql statement and execute it.
2. Prebuild stored procs for each combination. Call these from one central proc based on parameters passed in.
Steve...
August 27, 2002 at 10:00 am
I read a bunch of Mr. Celko's posts in Usenet when I was getting started and learned a lot.
However, as mentioned above. I like the punch card formatting for #1....
August 27, 2002 at 9:02 am
Change the password often. Develop a plan to avoid having this be cumbersome.
Profile and audit your server. If you catch people, deal with it administratively.
This is a reason why shared...
August 27, 2002 at 8:53 am
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
Viewing 15 posts - 37,306 through 37,320 (of 39,902 total)