Viewing 15 posts - 15,946 through 15,960 (of 39,944 total)
Right click the database, select "generate script" and there is an option to include permissions.
However the easiest way to move the database is a backup and restore. That will include...
June 12, 2011 at 9:57 am
June 12, 2011 at 9:56 am
First, if you've never done this, tell your manager you don't know how to do this. Screwing up a cluster without warning someone is way worse than anything else. You...
June 12, 2011 at 9:55 am
The database will restore with user permission. however logins are not part of a backup or restore. You can script them with sp_help_revlogin (from MS) and run the resulting script...
June 12, 2011 at 9:53 am
Blocking is normal. Excessive blocking is not, but you'd need to monitor over time to know if the blocks are held for a length of time.
What you ought to do...
June 12, 2011 at 9:51 am
AFAIK, this data isn't stored. I think the maxes are kept, but a very limited amount of data is stored overall. I think it's just related to the queries in...
June 12, 2011 at 9:50 am
The agent does the copy, but the restore is always handled by the engine. The log shipping agent (sql agent or proxy accnt) "asks" the engine to perform a restore,...
June 12, 2011 at 9:48 am
I'd tend to agree with Grant. Raise the threshold. You don't want queries unnecessarily grabbing codes to execute in parallel if they aren't sufficiently complex.
June 12, 2011 at 9:47 am
I'm not clear what you mean. Are you looking to read the names of all the files and store them in a table or something more?
Does this help? http://www.sqlservercentral.com/blogs/stratesql/archive/2011/1/31/31-days-of-ssis-_1320_-importing-execution-plans-_2800_30_2F00_31_2900_.aspx
June 12, 2011 at 9:45 am
To add to Grant, when you restore a database, or a log, the engine does redo/undo, which is essentially rolling forward and rolling back. Items in the log that were...
June 12, 2011 at 9:43 am
If you are trying to log all data changes from any column in any table, you are going to make coding this very complicated.
You'd be better off building a template...
June 12, 2011 at 9:39 am
How about Most Valuable Lurker, Bob? We could quiz you in Dec on the contents of The Thread
June 12, 2011 at 9:36 am
No need to apologize, and we want you to ask questions, but really more pointed questions. The suggestion to Google is for you to try to learn something about it...
June 12, 2011 at 9:33 am
You can index some native type documents, like Word as well. I would assume PDFs would count, but you'd have to experiment
http://www.codeproject.com/KB/architecture/sqlfulltextindexing.aspx
June 12, 2011 at 9:31 am
But you know what the new data is, so why can't you send in the audit first? Or select the OLD data and store it before the update?
If it doesn't...
June 11, 2011 at 4:31 pm
Viewing 15 posts - 15,946 through 15,960 (of 39,944 total)