Viewing 15 posts - 15,901 through 15,915 (of 39,901 total)
Did you set an sa password? Did you add your account as an admin during setup?
Also, you aren't necessarily running as administrator on the local machine. Shift right click the...
June 12, 2011 at 9:59 am
If you changed the email in your account, all posts move with the account. You still have 433 points, which I assume mean posts.
How are you searching for posts?
Also, please...
June 12, 2011 at 9:58 am
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
Viewing 15 posts - 15,901 through 15,915 (of 39,901 total)