Viewing 15 posts - 37,171 through 37,185 (of 39,769 total)
I think this varies so widely that it's tough to have a good checklist that you're not skipping items. A good idea, just not sure it's something that works well.
Things...
August 28, 2002 at 10:22 am
Not sure this makes sense. You get a restore error while the backup is running? If the backup is running, you will not be able to restore the system. Or...
August 28, 2002 at 10:19 am
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
Viewing 15 posts - 37,171 through 37,185 (of 39,769 total)