Yes, There are no settings in SQL Server.

Backup Devices can be a tape drive or a disk file. Some times u need to take backup to a tape drives automatically at that time backup devices are helpful.

Nice Script it help me a lot.

I have tried to solve it in alternate way but through t-sql you will definitely need permission on sys tables.

Omeswar Danwada

Hi, I am Attaching the procedure for creating Standard Maintenance plan, we are following the same in our project it is working fine for us, Try this out.

Omeswar Danwada

Thanks,

As i have two log files in my DB, how can we know that which Log File is Active.

I also did the same thing, But my question when we login with say for example 'Login1' account and is it possible to delete the same Login 'Login1'. You said...

COOL_ICE,

I tried to delete SQL Login while i Loged in, but its not deleting. Can u tell me how u do this.

Thanks,

Omeswar Danwada.

Hi,

Try the following

DECLARE @LoginName sysname

DECLARE @sql NVARCHAR (2000)

BEGIN

DECLARE cur_Loginfetch CURSOR FOR

SELECT [name] FROM master.sys.server_principals WHERE TYPE = 'G'

...

I too agree with Ananth. Can u explain how u did that. 🙂

use DTUTIL, Here is the link with an example.

http://www.databasejournal.com/features/mssql/article.php/3734096/Using-dtutil-to-copy-SSIS-packages-stored-in-SQL-Server.htm

Hey You can uninstall the SQL Server 2005, I have tried it on my Local PC i didn't face any issues. But make sure that you have moved all the...

Just now i have checked in my system, i am able to start and stop the services.

check this link

http://technet.microsoft.com/en-us/library/dd335968%28office.12%29.aspx

Hi,

Generally with SA rights u can start or stop the services of a server. Send the error what u r getting.