You need to fix this too: loannum >='999824 <=1000085'

loannum

Between '999824' And '1000085'

Yes, but only one at a time. You can't execute a procedure and specify the parameter as both an output and input parameter. So the limitation really is how you...

I do this for my weekly pull of backups to our test environment. You can make this easy by including some options in you Dir command. Here is a snippet...

I agree with Colin. You'll get much better performance if you avoid using dynamic SQL. I know that it's required sometimes, but if it can be avoided it should. Try...

Or do what I did.  Get a new job that gives you what you're lacking in your current job (especially if the current job refuses to allow you the opportunity...

I had planned on writing an article on this subject and never got around to it. You beat to it and covered some stuff I hadn't planned on covering (sys.dm_db_index_usage_stats).

Good...

You wouldn't use a trigger in this example. Food type would be a static list of food types and would not reference the Food table at all. The food table...

To run the restore job remotely, call it like this:

EXEC msdb4.msdb.dbo.sp_start_job @job_name ='LS - Restore Database'

To run the procedure remotely, don't use OpenQuery. OpenQuery is not a multiple dataset reader....

You can have different views in the other database that select from the views you just created. This is what I stated yesterday.

You're not listening. Create the views in the same database as the tables.

In case you mised it: SAME DATABASE AS THE TABLES

Create the views locally on the server that has the tables. Grant Select rights on the views to the account. Deny all rights to the underlying tables to the accounts....

This is SQL 2005. Don't use Text data type/columns. Use XML or varchar(max) or nvarchar(max) data type/columns. And use the SQL Bulk Import I mentioned.

It's not a permissions issue. It's the way he s calling the procedure. Until he posts that code, we can only speculate.

Thanks for the update. Please let us know the final outcome. I've never used DTS packages in this manner. I've only ever intended them to have a single instance running...

It doesn't seem so wierd if you use it correctly.

SELECT

'This is '+CASE WHEN Null