Viewing 15 posts - 166 through 180 (of 325 total)
Supernova Hakeem (2/21/2011)
What tool should I use to run this script? Thanks.
Nothing new :-). The *.vbs files are to be created via NOTEPAD, and simply double-clicking the file should be...
February 21, 2011 at 9:09 pm
Had a quick look at the script - it is a VB script that does pretty much the same thing - iterate through and export all available DTS packages as...
February 16, 2011 at 9:42 pm
A little bit of manual intervention will be required, but the search will be automated. Here's how:
1. Open the DTS package in the DTS Designer
2. Save the package as a...
February 16, 2011 at 2:46 am
Good one! I had to refer BOL for this one because we don't use Bulk-logged mode, but it was fun learning something new today. Thank-you!
February 15, 2011 at 10:21 pm
Tom.Thomson (2/14/2011)
Sourav-657741 (2/13/2011)
The Resource database (mssqlsystemresource)depends on the location of the master database. If we move the master database, can't the resource database also would follow the master database?
No, in...
February 14, 2011 at 7:43 am
Hello!
This can be done in two ways:
1. Have a check-sum column. Compute the checksum of the row and if the checksum is different from the stored value, something changed
2. Try...
February 14, 2011 at 7:37 am
I agree with Gail.
Anyway you can have a second drive attached to the server? That way, you can have the database (or part of it) restored there for the cleanup...
February 14, 2011 at 6:59 am
You also need to shut down the SQL Server instance, remove the single-user mode parameter and then restart the instance to complete the restore.
Is this where you are facing the...
February 14, 2011 at 6:53 am
Good question, Hardik! Thank-you.
February 14, 2011 at 12:52 am
I guess it's more of how one has grown up with things. When I was in school, one of the "skill" subjects that we had was typing (the good, old...
February 8, 2011 at 12:44 am
Hello, Tejaswini!
It's okay to be confused. Not a problem. I appreciate the fact that you asked for more clarification.
The point illustrated by #3 is, in itself the answer to #4....
January 28, 2011 at 6:12 am
Thinking in even more detail, I believe the definitions vary between on-premise and hosted deployments.
In my opinion, hosted environments need to include both the scheduled & unscheduled downtimes in their...
January 28, 2011 at 6:06 am
I do believe that scheduled maintenance windows should not be counted in the uptime guarentee because of the same reasoning mentioned in the editorial - scheduled maintenance windows are planned...
January 27, 2011 at 11:10 pm
You can think of using the "EXECUTE AS" option. In this scenario, the stored procedure will be executed after impersonating as whatever user you mention.
Hence, you can have a user...
January 19, 2011 at 2:21 am
Hats off to you, Paul! Excellent article. Very beautifully explained via the use of a nice, gripping story that evolves itself into shape.
Thank-you!
January 18, 2011 at 12:20 am
Viewing 15 posts - 166 through 180 (of 325 total)