Jonathan AC Roberts (5/15/2014)

---

...but if the entry of the parameters is from an external input, e.g. a web page, then it could be vulnerable to SQL injection - something that...

MG-148046 is right.

...but I can tell what the issue is. Kerberos multiple hops. You are starting from your client connecting to server 1 and then trying to connect to server...

I hate to be picky, but:

if exists (select * from sys.openkeys where key_name={key_name})

close symmetric key {key_name}

If you try to close it twice by accident, you get an error:

(The key {key_name}...

This should work if you run it from the folder where your files are, quick and dirty:

for %%R in (*.sql) do sqlcmd -i "%%R" -S {server_name} -U {user} -P {pwd}...

You can insert the value pairs in the temp table (or a permanent one, if you do this on a regular basis):

declare @t table (t1 varchar(16),t2 varchar(16))

insert @t values ('1001099548','1001099550')

insert...

This might help you, I scripted it out. Run it through the other account where you can see the DB.

USE [master]

GO

CREATE LOGIN [domain\your_domain_account] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

GO

USE [your_DB]

GO

CREATE USER [domain\your_domain_account(or...

I'm afraid, you need to be in 'sysadmin' role to do that. Check 'print user_name()' and see what permissions that login has.

mr_effe (4/23/2014)

---

Hi,

Yes perhaps it could work over the indirect way by a temp table and switch partition. But the problem exists not only for one process. There are many other...

Is there a reason why not do it like this (not that it'll make any difference in the locking)?

INSERT INTO t_target

SELECT 1 as pa_Attribut

,id

,SpalteA

,SpalteB

,SpalteC

FROM

t_quelle_1

You might try to do the insert...

I use select because I'm flat out lazy:

declare @i int,@j int

------1------------

set @i=1

set @j-2=2

------2------------

select @i=1,@j=2

-------------------

--and you can do:

declare @i int,@j int

select @i=1,@j=2,@i=@i+1,@j=@i+@j

select @i,@j

Which makes more sense if you're iterating...

Toreador (4/14/2014)

---

I agree with Tom, that None of the Above is probably the best answer (though I went for running in dev).

NOEXEC is definitely not correct though. Just try this

SET...

You might want to check for blocking due to schema locks when modifying a column.

The columns that I need from the stored procedure called StudentData will return the following data columns

that I need for the report: StudnentName, StudentAddress, Studentbirthdate, StudentPhoneNumber,...

No it's not compressed. It was completely different issue. The particular FG was pointing to a non-existing file. I talked to MS and the solution they came up with was...

nmederich (1/11/2011)

---

I'm sharing the answer that i found in the hopes it helps someone else.

Why did this occur? I could be wrong but my theory is this:

I had been...