Viewing 15 posts - 28,276 through 28,290 (of 39,961 total)
This is an application problem. You probably need to manually insert the admin record into both tables from EM (Enterprise Manager) or QA (Query analyzer)
June 21, 2008 at 10:04 am
I'm not sure there are any great dedicated resources. The books are a good place to start, applying the concepts from them to your environment.
you can also try sqlis.com
June 21, 2008 at 10:03 am
It depends.
clustered index better for range scans, nonclustered better for specific rows, covering always good.
June 21, 2008 at 9:58 am
I'd do the first listed above, but script out the tables and dependencies from SSMS, modify the scripts, and then run them to alter the tables.
If you alter a table...
June 21, 2008 at 9:58 am
The advice above is correct. As far as I know, only SQL Prompt from Red GATE can do this in 2005.
June 21, 2008 at 9:56 am
If you stopped the server, you should be alright as mentioned above.
What you did makes sense with that many databases and this should have speeded up the process. The thing...
June 21, 2008 at 9:56 am
Autogrows can slow performance and fragment the file on disk. The impact depends on your system.
you should be monitoring space, keeping enough pad in the files for 3-6 months, and...
June 21, 2008 at 9:54 am
How are you doing the restore and exactly what happened? Also, have you run a checkdb or restore verifyonly on the files?
June 21, 2008 at 9:53 am
Are you restoring to the same external disk or the internal disk you had issues with?
Can you restore the file on another machine?
The error message and exact steps would...
June 21, 2008 at 9:52 am
SQL Apprentice Jeff...has a nice ring to it. Maybe we can chip in for a pointy hat for you to wear to the meetings 😉
June 21, 2008 at 9:49 am
Everyone is right, not sure how sp_describe_cursor_columns got chosen as an answer. Must have been a bad day 🙁
Busy this week, so I've missed this thread until now. The QOD...
June 20, 2008 at 12:44 pm
Hyperbac are the same guys that originally built Litespeed (from DBAssociates way back when). They've got a lot of experience and since you have lots of choices now (MS, Red...
June 20, 2008 at 11:22 am
And if you don't group emails by sender (I don't), be sure that you read from the newest to oldest. I've often found a note that something critical needed a...
June 20, 2008 at 11:18 am
There are a few things to check.
First, not sure which version of Windows you have, but in some versions there is a different kernel for 1 CPU or multiples. I'd...
June 20, 2008 at 10:53 am
Viewing 15 posts - 28,276 through 28,290 (of 39,961 total)