Viewing 15 posts - 41,536 through 41,550 (of 49,562 total)
You can use the windows scheduler and sqlcmd to do scheduled backups. It's not as easy as SQLAgent, but it does work. For sqlcmd, you'll want to use the -i...
January 21, 2009 at 1:14 pm
JKSQL (1/21/2009)
which process is faster and better for longevity?
Depends. Test them both under load and see which one scales better. Sometimes the temp table is better as...
January 21, 2009 at 1:05 pm
My guess is that it found a possible index inconsistency in that table. (row in cluster that's not in the noncluster or vis versa)
The way the checkDB algorithm works is...
January 21, 2009 at 12:51 pm
pixye.sb (1/21/2009)
you mean that a user having the role db_datawriter on msdb has by default the same privilege on all databases in that instance?
No. A user with the db_datawriter on...
January 21, 2009 at 7:27 am
thulani.moyana (1/21/2009)
January 21, 2009 at 7:25 am
It's in the database properties. From object explorer, right click the database and select properties.
It's also probably available with one of the DATABASEPROPERTYEX options
January 21, 2009 at 7:24 am
Why would it need permissions in tempDB? Temp table usage doesn't require any permissions in tempDB, so unless there're doing something like creating permanent tables in tempDB (which the permissions...
January 21, 2009 at 6:57 am
And just note there is a 16 column/900 byte limit on index key size.
Edit: 16, not 60.
January 21, 2009 at 6:52 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
January 21, 2009 at 6:50 am
Disclaimer: Do not do this on a production server. Do not do this to any database that you care about. If you want to play, do so on a SQL...
January 21, 2009 at 6:33 am
xanthos (1/21/2009)
Update:I've restored last nights backup of master as a userdatabase and run DBCC CHECKDB ALLOW_DATA_LOSS.
This solves the consistency errors.
Yes, it's fixed the corruption, but do you know...
January 21, 2009 at 6:30 am
Andrew Gothard (1/21/2009)
the advice about driving off a cliff
Depends. On occasion I have given such a warning even though the OP was short of manners. It's got me sworn at...
January 21, 2009 at 6:21 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic640326-149-1.aspx
January 21, 2009 at 12:17 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic640430-147-1.aspx
January 21, 2009 at 12:13 am
ashepard (1/20/2009)
A temp tables are formed for rows fetched
They are?
January 20, 2009 at 11:56 pm
Viewing 15 posts - 41,536 through 41,550 (of 49,562 total)