Viewing 15 posts - 28,081 through 28,095 (of 39,769 total)
This is a complicated subject and we can't necessarily give you a complete explanation on encryption. I'd suggest you read in BOL and articles on building encryption into an application....
June 21, 2008 at 10:09 am
Wither you have to pass all values, or unpassed values need defaults in the stored procedure definition.
You can specify specific parameters as
exec mystoredproc @param2 = 4, @param4 = 65
But if...
June 21, 2008 at 10:06 am
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
Viewing 15 posts - 28,081 through 28,095 (of 39,769 total)