Viewing 15 posts - 31 through 45 (of 1,335 total)
You have a backup delete task in SSIS which can be used to specify the location where the backup files reside. Why can't you use that.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 29, 2008 at 9:13 am
Do you have remote connection set to on on your server?
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 29, 2008 at 9:05 am
Do they have any tables in command in so are there any common columns and the list goes. do an impact analysis and then use the SSIS to move tbales...
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 29, 2008 at 9:03 am
The easiesrt method to do is use SSMS and then delete the login from the security folder.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 29, 2008 at 8:59 am
Check if any application is using more hassh tables and they are plenty of rows in it. They are the usual cause for that.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 29, 2008 at 8:54 am
Move the tempdb to RAID 1 and then put your executables in a other drive than the boot drive.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 29, 2008 at 8:46 am
The default is the one that has been passed on the last rebuild command and does not take the systems initial default value.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 29, 2008 at 8:45 am
Hey i would go with the Database tasks done only by the DBA and let the admins take care of the network and OS related tasks. I would prefer the...
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 29, 2008 at 8:43 am
Check if the script in the link helps.
http://www.sql-articles.com/index.php?page=Scripts/encrypt_decrypt.html
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 5:39 pm
Is this solved.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 5:35 pm
Grant execute permission to the SP on msdb.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 5:34 pm
You have the transfer jobs abd DTS tasks in the DTS so yo can use them to move to the other server.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 5:30 pm
Use the query in the link below and store the result in a excel file
http://www.sql-articles.com/index.php?page=Scripts/permission_list.php
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 5:29 pm
Query the sysdatabases to find which databases is currenly running with users. You can also find the database not being used by tracing the activity.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 5:28 pm
But why do you change the page file. To my knowledge it will not help your sql server anyways.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 5:25 pm
Viewing 15 posts - 31 through 45 (of 1,335 total)