I think I see what's going on. You need to make sure that NT AUTHORITY\SYSTEM has permissions on the remote server. Either that or make a different login...

Try using brackets ([]) instead of inverted commas ("") to enclose your server name.

John

I would advise you not to shrink your logs regularly. Let them grow to whatever size they need to be and then leave them. You can reduce the...

I don't think you want to do it globally if it's just for SELECT statements. Just use the NOLOCK hint in queries that you don't want to lock the...

ben.ashton (3/28/2008)

---

I am still slightly puzzled though as on our test database we were getting PAGE level locking, until we re-built the Unique Clustered Index on the CONTACT table. ...

Are your statistics up to date? If not, then the query optimiser might not be able to make the correct decision about what type of lock to take for...

Why is this a problem? If you want to select everything from a table, then you need a lock on the whole table. It doesn't matter whether that's...

Something like this:

INSERT INTO LOGLOG (destination, [content])

SELECT phonenumber, 'hello world'

FROM USERLIST

where OWNERNAME LIKE @name

John

Diann

Are you sure you need the join at all? From the data you've provided (which looks as if you've simplified it quite a lot), it appears that this will...

This is a little bit confusing. Please will you provide table DLL in the form of CREATE TABLE statements, some sample data in the form of INSERT statements and,...

Yes, I think you can use an XML file, although I've never done it that way myself. I think you'll need to study this area quite carefully since it...

Are you sure about that? Can you not create a different configuration filter for each package, and store them in a SQL Server table? Then, when your file...

Das

The SSIS equivalent of dynamic properties in DTS is Package Configurations. You'll probably need to do a bit of reading about it, since I don't think it works in...

I don't know because I haven't tested, but I would guess that ALTER and DROP/CREATE would both cause the procedure to be recompiled at next execution. This is a...

Marios

Probably best to use the system stored procedure sp_helprotect.

John