Viewing 15 posts - 8,416 through 8,430 (of 9,720 total)
BOL (Books Online) is also a good resource.
I'm pretty sure that backing up a standby database is not really any different from backing up a regular database.
March 10, 2009 at 6:22 am
I have rarely seen stored procedures that call other stored procedures. Mostly they call functions.
Have you tested your Exec statements yet? Your pseudo-code looks basically correct.
March 10, 2009 at 6:20 am
Another suggestion is to look at the DBA cert books. Not to study for an exam, but because some of the better cert books give you detail by detail how...
March 10, 2009 at 6:18 am
I can't count the number of times that a wrong phrase in Google had me chasing ghosts. @=)
Glad I could help. And thank you for posting your resolution. That should...
March 10, 2009 at 4:40 am
I'm going to reiterate what I said earlier.
Use DDL triggers to log changes to a table in an Admin database. Use a Datetime column to log the time the...
March 10, 2009 at 4:37 am
Glad we could help. @=)
And thanks for posting your solution.
March 10, 2009 at 4:28 am
We actually have this working with attachments, but it's been a while since we set it up.
However, just got a new Dev cluster, so I'll play with it in the...
March 10, 2009 at 4:23 am
As soon as I find some data and code I can post without having to sanitize it first, I'll put up an example.
March 10, 2009 at 4:21 am
RBarry,
Depends on the situation. You can't always fix the Group By. Sometimes it screws up your result set if you do.
Believe me, I've tried that. Sometimes fixing the Group By...
March 9, 2009 at 12:22 pm
Wait a minute. I just looked at your data again. You're not doing a pivot. Not even close. Pivot is where you change your columns into rows and rows into...
March 9, 2009 at 11:48 am
Matt's correct. You have to have a PIVOT to aggregate your rows onto the column. Otherwise, what's the use of the pivot?
Of course, you can put a dummy aggregation in...
March 9, 2009 at 11:43 am
Oy, I wish!
However, there's a minor workaround.
Register all your servers in the "Registered Servers" sidebar. Keep that pinned open so every morning, all you have to do is doubleclick...
March 9, 2009 at 11:40 am
Aha! Remembered what it was. This is a poor example because I can't give you my real data and I had a much more complex query. Suffice to say, though,...
March 9, 2009 at 11:32 am
Sounds to me like the test script is trying to alter some other account's login / permissions information. That might be why it needed SA access. Of course, the account...
March 9, 2009 at 11:14 am
PerfMon can also be used to check things like RAM usage, even for SQL Server. I can't remember which SQL Server counter it is, though, off the top of my...
March 9, 2009 at 11:10 am
Viewing 15 posts - 8,416 through 8,430 (of 9,720 total)