Viewing 15 posts - 28,666 through 28,680 (of 39,771 total)
Doesn't seem correct. I wouldn't think there would be uncommitted transactions after a restore. After a restart from sudden stop, but not a restore.
May 7, 2008 at 3:12 pm
Tom,
Feel bad for you and it sounds like a bad plan got pulled into memory. I don't suppose you have a copy of the "good" plan? If not, grab one...
May 7, 2008 at 3:10 pm
No, server roles do not impact database permissions.
Are you creating databases on the fly? Why not add a standard NT group to the db_datareader when you create the db?
May 7, 2008 at 3:02 pm
Maybe you should explain the issue a bit more from your side. It's not quite clear what you called about and what the symptoms are.
May 7, 2008 at 3:00 pm
Interesting items from Chris and it probably is worth another editorial (or maybe Chris wants to write one) about it. I'd say that being early hasn't mattered to me, but...
May 7, 2008 at 2:52 pm
Unless you're snagging rowcounts when you backup, how can you determine things are successful? How do you know you restored the right file?
It's an interesting question, and ultimately you might...
May 7, 2008 at 9:29 am
xp_startmail
Will start or return "started" or return an error.
May 7, 2008 at 8:39 am
Not sure. Is this from SSMS when you're selecting the database (right click), properties?
May 7, 2008 at 8:30 am
I think that the DBCC PAGE command might work here, not knowing if you have the required information, but as Matt mentioned, why do you need to do it this...
May 7, 2008 at 8:29 am
How large is the log? It sounds like a network error. Does it work if you restart the job?
May 7, 2008 at 8:26 am
I would also use the Windows service level options to restart the service and perhaps send an email using a script.
May 7, 2008 at 8:26 am
If you can view it in SSMS, the instance is started. In SSMS, however, are you registering/connecting to "YOUR-16EFCDA" or "YOUR-16EFCDA\SQLEXPRESS".
May 6, 2008 at 10:18 am
I suppose the default might technically incur slightly more resources to find the default and add it to the table (not sure if this is done inline or in a...
May 6, 2008 at 10:15 am
sp_OACREATE and use the filesystem object to snag things.
Parse an xp_cmdshell 'dir' result set.
Or even write a VBScript that can get the infromation and insert it into your table (I'd...
May 6, 2008 at 10:13 am
Viewing 15 posts - 28,666 through 28,680 (of 39,771 total)