you can change the default settings for your connections in SQL Server Management Studio in the Tools>>Options menu

as soon as you change it, that would affect all NEW query windows...

in that case, everyone who has CREATE DATABASE permissions must also have INSERT permissions on the logging table

INSERT adminlog.dbo.dba_ddl_events

no insert permissions (line 13, right, like the error said?) would cause...

dbadude78 (8/31/2012)

---

Yes I have got a DDL trigger, I have disabled it and it works now. Thankyou for your help 🙂

The reason i put the triggers was to monitor when...

the error message:

i think...

you could use the linked server instead of open query, or switch the whole openquery command to be dynamic SQL;

that's all i can think of.

I think the issue is related to OPENQUERY (linky to BOL) ;

it requires a static string as the second parameter, so you cannot...

this question comes up a lot; I've had to do this when a web page name changed, for example, and who knows what content exists out there with the old...

did you create the matching USER devtest in the database where the procedure was created?

did you grant execute to the user devtest ont eh procedure?

CREATE USER devtest FOR LOGIN=devtest

GRANT EXECUTE...

dbadude78 (8/31/2012)

---

Hi

Thanks for the quick reply. As a test i executed the whole script on my local instance. But got a the following message "Msg 297, Level 16, State...

here's another model for you to use as well:

--http://www.7-zip.org/download.html

--http://downloads.sourceforge.net/sevenzip/7za920.zip

--xp_cmdshell is limited to ONE set of double quotes.

--one of the paths needs to not contain spaces!

--see 2003 MS KB http://support.microsoft.com/kb/266224

DECLARE @results...

glad I could help!

not sure what the specific issue is; this works perfectly fine, whcih is just the scripting of what you said you did;

note i'm using EXECUTE AS to directly test the...

you are just missing the AS keyword...and global tables have double # marks (##GlbalTemp):

it's probably a good idea to put explicit BEGIN-END markers as well.

do you want to create if...

you are probably in good shape.

if the expected directory structure is there, like if you were backing up to N:\SQLServer\Backups, no problem.

if the folders are missing, it will fail. in...

there's a decent thread on stack overflow that gives examples and links; note the first answer about REF CURSOR is for oracle...ignore that.

http://stackoverflow.com/questions/552613/how-to-call-storedprocedure-from-crystalreport

---

probably relevant for you:

Try Database Expert -> (left...