Viewing 15 posts - 19,636 through 19,650 (of 22,213 total)
And then only if it's a publicly traded company. I've been working for a private company for years, so I'm only aware of SOX when I hear people complaining about...
September 4, 2008 at 5:33 am
You don't have to create the shell to restore a backup to a new database. You just have to move the data files. I explained the GUI method in the...
September 4, 2008 at 5:28 am
I am such a dope sometimes.
http://www.sqlservercentral.com/articles/Backup/recoverytoapointintime/1914/%5B/url%5D
September 3, 2008 at 12:28 pm
It sounds like your maintenance plan is set up right. The scenario you described is not because of a database or log first or second, but because you have to...
September 3, 2008 at 12:22 pm
Maybe I'm confused (hardly a new case), but however many log files you've backed up, you'll have to traverse them unitl you get to the log where the end time...
September 3, 2008 at 12:11 pm
You can't really do logs first. You have to restore the database and then a series of logs and the backup has to be in the same order.
September 3, 2008 at 11:55 am
Those files are not compatible with Management Studio.
As to where... it really depends on your shop and the processes there. For example, we use Visual Studio Team System Database Edition...
September 3, 2008 at 11:53 am
Didn't I answer this one already today for you?
September 3, 2008 at 10:33 am
But the issue is the error message:
"nvarchar value "2147486776" overflowed an int column"
If you're selecting into a bigint variable from a big int column, where is the nvarchar and the...
September 3, 2008 at 9:14 am
Have you tried running the query against the base table?
Something is introducing a string in there.
September 3, 2008 at 9:08 am
And RecId is, for sure, a bigint?
September 3, 2008 at 8:39 am
Well, to get it to execute 10 times, just use this syntax:
EXEC myproc;
GO 10
As to how to gather the average of 10 executions... It depends on how you're capturing the...
September 3, 2008 at 8:37 am
It's possible your external IP address has changed? You shouldn't be sending people your internal IP address because it won't help them.
BTW, this is a SQL Server 2008 Forum. You...
September 3, 2008 at 8:12 am
Excellent! Looking forward to it.
September 3, 2008 at 7:00 am
Viewing 15 posts - 19,636 through 19,650 (of 22,213 total)