This sounds like the SQL Agent Login doesn't have permission to write to the remote server. Check to make sure that SQL Agent is set up with a login that...

Sounds like the perfect reason to lobby for a dev box! How are you supposed to make sure you don't cause down time if you don't have the ability to...

Instead of using Top n try setting the rowcount as follows.

SET ROWCOUNT @NumRows

SELECT ....

SET ROWCOUNT 0 -- Don't forget to do this as soon as you don't want to limit...

You might try using the OPENQUERY syntax to do the select rather than the fully qualified syntax. I don't have the ability to test this right now as I'm at...

Yes you would still need to use the wildcard. Or you might try using the regular expression engine using a range ( LIKE ('Mu[n,ñ]oz')   Note that I don't have the ability...

I'm not going to argue the political aspects of the above statements. However the following does work...

CREATE FUNCTION f_DeleteFile(@vFileName nvarchar(528))

RETURNS int

AS

BEGIN

    DECLARE @cmd...

Better yet hit Ctrl+D and return the results in the data grid

Well let's see. If you write it as a function then I would think you would want to write it such that only one folder at a time is deleted...

You...

It looks like they are XML values that the Query Analyzer looks for when doing the "Replace Template Parameters" dialog box. My guess is that Query Analyzer looks at these...

You can also create multiple "Alternate" keys by using unique indexes.

Actually not odd when you think about it a little. The distinct is carried out after the concatenation is done. So you only get 1 result anyway.

What happens if you add the following before your create statement?

SET QUOTED_IDENTIFIER OFF

GO

SET

ANSI_NULLS OFF

GO

-- Put...

JB,

If you have Visual Studio .Net you can create a database project to hold your script files. Then you can simply right click on the folder you want to create...

The problem with writing this to the database in a transaction and holding the transaction open is it will effectively lock the affected tables until the transaction is commited.

We...

As Antares stated you can use sp_start_job but if it is running you will get an error. I needed to do something like what you seem to want and here...