Viewing 15 posts - 976 through 990 (of 2,636 total)
You could use a query like this that checks sysjobhistory:
select distinct j.Name as "Job Name", h.run_date as LastStatusDate,
case h.run_status
when 0 then 'Failed'
when 1 then 'Successful'
when 3...
June 9, 2008 at 10:21 am
Follow ahutch's last link to get to the DTS run-time components you'll need to run the legacy DTS packages in SQL 2005. I haven't done an in-place upgrade, but...
June 9, 2008 at 9:26 am
Do you own the package? Please post the entire message.
June 9, 2008 at 9:18 am
That's why you need the proxy. Non-sysadmins, by default, cant' start and manage jobs. Here's what I did:
1. Create a SQL server login that will be used for...
June 9, 2008 at 9:06 am
June 6, 2008 at 11:38 am
Good luck. I'll be watching to see if I can provide any more help so you can learn from my mistakes!
June 6, 2008 at 10:46 am
"I understand that you have to somehow set the compatability, but HOW do you do this?"
Unfortunately, you can't change the compatibility level to 9.0 while the database is still...
June 6, 2008 at 10:02 am
I've just gotten this to work using a stored procedure that starts an unscheduled job that executes a package. The web application executes the stored procedure using a SQL...
June 6, 2008 at 9:45 am
Not much information to go on, but I'll take a stab. Did you map a local login to a remote login in the linked server? You might try...
June 6, 2008 at 9:37 am
You can script most things like linked servers, logins, and jobs in SSMS. It's especially easy if you open the Summary tab (F7), highlight all, right-click, and script. ...
June 6, 2008 at 9:30 am
Integration Services is not part of SQL Server, but runs as a seperate service. Thus, it doesn't know anything about SQL Server logins. You can use SQL Server...
June 6, 2008 at 9:25 am
1. Perhaps you're not executing the package on the server as the same account that created the package. Set the package Protection Level to something other than "DontSaveSensitive" or...
June 6, 2008 at 9:18 am
Congratulations. Check out the links in Jack's signature block about what info you need to provide to get good help in forums.
June 4, 2008 at 2:45 pm
The error message is pretty clear. You have to specify a column list and turn IDENTITY_INSERT on. Please post the INSERT statement.
June 4, 2008 at 2:42 pm
The easiest way to do this is to backup the database you want to copy and restore the backup to a new database with a new name. You can...
June 4, 2008 at 12:50 pm
Viewing 15 posts - 976 through 990 (of 2,636 total)