Viewing 15 posts - 16,666 through 16,680 (of 39,922 total)
First, don't shift to your domain account. That's a poor security practice, and depending on how your account is managed, it could be an issue.
Create a new domain account, with...
March 12, 2011 at 5:34 pm
Me too, now if they'd move a few more features, I'd be thrilled.
March 12, 2011 at 1:24 pm
What do the stats show you? Does it hang at the beginning? the end?
March 12, 2011 at 1:23 pm
Likely the statistics for the Content column indicates the is might be enough rows with a '', that it's worth just scanning the table. Even if you think it's quicker...
March 12, 2011 at 1:22 pm
It is scary, but requiring local access mitigates it a little. It's a back door that's designed this way, specifically for the people that forget SA or have a rouge...
March 12, 2011 at 1:20 pm
Glad it's working.
Data types are important in SQL Server, and you were relying on some implicit conversion to match a date to a character. That doesn't always work, and it...
March 11, 2011 at 6:01 pm
This is a merge issue, and I've had it happen with systems getting merged. Typically what you have to do is allow the new parent system to determine how data...
March 11, 2011 at 12:42 pm
DAC and command prompt are not the same. DAC can be used from Management Studio. If you have it open when you start up the instance, connect with "Admin:" and...
March 11, 2011 at 12:32 pm
Sorry, for the in place upgrade, things are fine.
For the side by side move to new hardware, sp_help_revlogin will let you script logins. Once you get the script and run...
March 11, 2011 at 12:05 pm
The roles will be moved over as is. There are issues moving security to a new server, but for an in-place upgrade your logins will remain and they will map...
March 11, 2011 at 10:51 am
Did you start the SQL Server in Single user mode, and are you connecting with the DAC connection?
March 11, 2011 at 10:34 am
I usually have called myself the data janitor. Makes people laugh and disarms them a bit from the last DBA being too self-important.
March 11, 2011 at 9:41 am
Looks like 512GB right now is the high response. My friend had 1TB in a server, and was considering moving to 2TB as data sizes grow
March 11, 2011 at 9:33 am
There's no way to remove access from within the database. It's contained on the server, and the server determines access, as of SS2K8R2. If they are restoring the database, then...
March 11, 2011 at 8:54 am
My apologies. Points have been awarded back to the people that have answered and the question has been corrected.
March 11, 2011 at 8:36 am
Viewing 15 posts - 16,666 through 16,680 (of 39,922 total)