How cant i get this to work.
USE master
DECLARE @sql nvarchar(1000)
declare @db_name as varchar(255)
SET @db_name='msdb'
SET @sql = 'USE ' + @db_name
PRINT @sql
EXEC sp_executesql @sql
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22118573.html
I am currently using SQL 7.0, and I want to know how to recreate jobs on another server. For instance, I have a server that has over fifty jobs created on it and I didn't want to have to re-define ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10331718.html
I have just installed a new HDD with Win2KAS and SQL Server 6.5 + sp5a but the msdb is marked suspect. I know 6.5 is not meant to be used on Win2K but it was working before in installed new HDD. Ho...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11323977.html
I need to move the master database, tempdb, and the msdb to a different drive. Does anyone know of any way to do this?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20549588.html
We had a major disaster and have to fully recover a server from scratch. The original database server had been running for some years. Now users are very interested in retaining existing SQL pack...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20585066.html
Hi All
What are the pro's and con's of moving the master/msdb dbs. I know how to move them but wonder if this is the best option.
A typical server has 3 disk sets (C:, D: and E:).
C: is inte...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21874724.html
How do I transfer all my DTS packages and jobs from SQL7 to SQL2000. Need an easy way because I have hundreds of packages.
/RG
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21886396.html
On SQL Server 2000, We received a page fault on the msdb database and all of our dts packages dissappeared. We are not able to restore directly to msdb but can restore to a new database (msdb2). ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_22733208.html
I removed all tasks from a development 6.5 SQL Server by deleteing * from msdb..systasks. However, there are still entries in the 'Running Tasks' window, and I can't stop them - "xxxtaskxx Not Fund...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11457638.html
When I try and start SQLAgent for SQL 7.0 SP3 it returns an error in the event log.
Error message is...
SQLServerAgent could not be started (reason: SQLServerAgent cannot start because the msdb d...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20451456.html
