Have you tried the syntax from my last post??

EXEC sp_addlinkedsrvlogin 'ExcelSource', false, sa, 'admin', NULL

Does the above work ??

Absolutely not!

GRANT EXEC to a sp that is owned by dbo and have the sp run the CREATE TABLE statement.

This way the developers DONT have access and YOU dont have...

I think (don't remember exactly) that you are missing the 2nd step which is to assign the permissions to the newly linked server.  Here is syntax to check

EXEC sp_addlinkedserver...

Create a stored-procedure that the developer/agent has EXEC permissions to that they can use to pass the properly formed syntax to CREATE TABLE that will check and ensure that they...

Duzit,

How often do you backup your system?  If you dont you can run the code below to clean-up the LOG, HOWEVER please be aware that IF this is a...

Balaji,

In the step that you are using the ? parameter did you define the parameter for use?

Open the Execute SQL Task > Click on Parameters button.  Click the drop-down in...

Sorry on that one Marc.  I don't work much with text fields.  The only thing I could think of is set-up three VARCHAR(8000) variables and just re-use them for each...

hmmm, how about

DECLARE @text1 VARCHAR(8000)

DECLARE @text2 VARCHAR(8000)

SET @text1 = LEFT(textfield, 8000)

CASE WHEN LEN(textfield) > 8000

  THEN SET @text2 = SUBSTRING(textfield, 8001, 8000)

ELSE SET @text2 = ''

CONCAT @text1 + @text2 and...

I would work with the Sysadmins and get them to schedule regular backups that would comply with your companies security policies and keep you and your data safe.

Ultimately, IF the...

As far as I know the diagrams don't go from server to server or even from DB to DB

Mark,

The only thing I can think of (down and dirty) is to either

A)  CAST(TextField AS VARCHAR(8000))

or

B) CONVERT(VARCHAR(8000), TextField)

and then concat it the above together

Good Luck

Why not PARSE the multiple values for the parameter INSERT them into a #table and then do a SELECT * FROM dbo.Customers WHERE Customer_Number IN (SELECT Customer_Number FROM #table))

Good Luck

I would try the refresh button first (just in case) if this fails I would research the sp_change_users_login and see if there are an "orphans".

Are you the dbo of the...

Alvin,

You may not have the rights to do this but the T-SQL commands are sp_attach_db and sp_detach_db.  You can learn more about them thru BOL or support.microsoft.com or from...

You need to qualify the columns you are INSERTing INTO.

INSERT INTO tblMail (Address1, Address2, City, State)

Select Name = @Name,

Address1 = @Address1,

Address2 = @Address2,

City = @City,

State = @State

IF you try and...