Viewing 15 posts - 35,971 through 35,985 (of 39,720 total)
Sorry, haven't used that version.
BTW, I think you'll find the consensus on this site from most experienced DBAs is not to use an agent.
Steve Jones
August 29, 2003 at 1:27 pm
Not sure if it can because the xp_cmdshell doesn't take a set as an argument.
Steve Jones
August 29, 2003 at 1:25 pm
They should be there. I'd install another instance and just copy them over.
Steve Jones
August 29, 2003 at 1:23 pm
We use TSM and the unique filenames are a blessing as we may need to go back to a particular day. You can setup a special retention polocy (which is...
August 27, 2003 at 5:03 pm
Tough one without more information. Indexing differently, reducing the set sizes byu perhaps moving data from tables might help. Indexed views might work depending on the update levels.
Of course many...
August 27, 2003 at 10:22 am
Nicely written Brian and shares many of my same views. I've tended to handle inappropriate access (like not using the applicaiton) administratively. A chewing out, a writeup, or a termination...
August 27, 2003 at 10:20 am
Was this an old name? I htink this is probably left over from an old maintenance plan. If under the Maintenance Plans folder (under Mangaement), there is not a maintenance...
August 26, 2003 at 2:58 pm
Also check the maint plan logs. Look at the properties for the maintenance plan to see where the job is being logged and check out the log files for an...
August 26, 2003 at 10:55 am
No, you'd need to compare each column. Comparing PKs is easy, but that won't tell you if all data is the same.
Steve Jones
August 26, 2003 at 10:53 am
I'll tell you what I did on an e-comm site. We had no financial stuff (no credit cards). We did have SSNs, phone, etc.
So we would restore every Thur for...
August 26, 2003 at 10:11 am
All are survey based and depend on the answers being correct. Some people inflate their salary to skew numbers, same could be said for companies (in the other direction).
Steve Jones
August 25, 2003 at 11:22 am
How can you ensure accuracy? The best you can do is go with the salary guides out there. Are you looking to hire or get hired?
Steve Jones
August 25, 2003 at 9:37 am
Are you looking for which server is active? Because the cluster'd server isn't "on" a machine. That's the idea.
Steve Jones
August 25, 2003 at 9:31 am
Some things work better, some don't. Haven't seen the need for the row number. Why do you need it?
Steve Jones
August 25, 2003 at 9:29 am
if you are running sp_password, you can use NULL for the old password.
Steve Jones
August 25, 2003 at 9:25 am
Viewing 15 posts - 35,971 through 35,985 (of 39,720 total)