I'm pretty sure what AlexSQLForums suggested will work. Only those local logins listed in the mappings box can access the linked server.

Am I missing something in your request?

J.D.

This is great feedback. It's actually a philosophical discussion here at the office. My personal reason for not just grabbing the file name only is that I use...

Seems like a bug to me if it only affects UDF's. Is there another solution for determining if a given table is being used? I need to track...

What's is doing from the DB perspective? Is it being blocked by some other process?

J.D.

Not a script, but you can always go to the windows services and look for it there. SQL Server Agent is the service name, I believe.

Thanks for the query. Exactly what I needed.

Turns out the login in question was set at the owner of the DB. It seems that by giving a login...

Before commenting on anything we have to investigate the system completely like

1. what DTS is doing?

2. at that time what all processes is going on?

3. any jobs run?

4. how many...

Now I'm stuck. If it's a 1, I want to move it. If it's a 0, I want to leave it alone. How do I connect my @IsTrue value to...

I've had a similar situation. You'll need two variables. One for the file name and the other save the value when you compare to the database. I...

I tried it both ways. When I specify the wrong table name it catches the error.

Error number: 208

Error message: Invalid object name 'susers'

Error Severity: 16

When I specify the correct...

Still on my quest to figure this out. I've noticed something odd. If I run the following code as a stored proc or directly as written I get

Msg...

I'm still getting this:

(0 row(s) affected)

I'm not surprised by this as it's written to purposely error out. Inserting 0 rows would be correct. My sample file has only...

I got the same results from using an exec statement. It seems to be tied with that type of error. If I change the insert statement to point...

I...

I personally don't like to use the method you describe as its very easy to overwrite an existing package because it does not give a warning.

If you log onto integration...