Viewing 15 posts - 1,906 through 1,920 (of 2,636 total)
Scott,
Enable cross-database ownership chaining between the two databases. It's off by default after SQL Server installation.
To enable: open properties of the database in Enterprise Manager, select 'Options' tab, check...
August 30, 2006 at 9:54 am
What does the package log say when the package is executed from the job?
If you previously specified a specific version of the package in the DTSRUN command in the...
August 30, 2006 at 9:35 am
You can set each step to retry as many time as you want with whatever interval you want.
Open the job properties in Enterprise Manager, edit the step, go to...
August 30, 2006 at 9:30 am
Yes. Also make sure that SQL Server Agent is started on the destination server.
Greg
August 30, 2006 at 9:23 am
Ron,
The easiest way to move jobs is to script them out and execute the scripts on the destination server. Here's a similar thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=304226#bm304671
Greg
August 30, 2006 at 9:21 am
Since job information is stored in msdb, you could backup and restore the database. This is only an option if you're moving to a new server that doesn't already have...
August 29, 2006 at 8:32 am
SQL Server has an IMAGE data type. See "image data type" in BooksOnLine. I recommend that you search for "image data type" on this site to get more opinions on...
August 28, 2006 at 10:23 am
We've been very happy with ApexSQL Diff http://www.apexsql.com/.
Greg
August 28, 2006 at 10:18 am
What do you see in the SQL Server log at the time the backup failed? How about the job history details? Right-click on the job in Enterprise Manager and select...
August 28, 2006 at 10:15 am
Well, yes, you have to specify which servers you want to copy to. You can put a Copy SQL Server Objects task for each destination server in a single package...
August 28, 2006 at 10:02 am
Try DTSBackup 2000 from http://www.sqldts.com/default.aspx?204 to transfer DTS packages. I've used it and it works great.
As for the schedules, when you schedule a package a job is created. Just...
August 28, 2006 at 9:59 am
For that matter, why not just have SQL Server Agent notify you when the job fails? See "Notifications" in the job properties.
Greg
August 28, 2006 at 9:54 am
In most cases it's best to store date data in datetime columns.
Transform the data to datetime data type (DTS can do this) and use date functions such as datediff to...
August 23, 2006 at 3:44 pm
Run a Profiler trace on the server filtering for the specific database. Be sure to capture ApplicationName,NTUserName, LoginName.
Greg
August 23, 2006 at 3:37 pm
Sorry, there's no such table. DTS packages are stored in the sysdtspackages table in msdb, but the package code itself is binary data stored in an image column.
I recall...
August 23, 2006 at 3:26 pm
Viewing 15 posts - 1,906 through 1,920 (of 2,636 total)