Viewing 15 posts - 601 through 615 (of 880 total)
Nice simple question to start the day, thank you Henrico, always good to be reminded of the basics.
May 15, 2017 at 11:07 pm
Very good question, had to check out BOL so something new to know, thanks.
May 4, 2017 at 3:41 am
May 1, 2017 at 8:33 am
April 21, 2017 at 3:51 am
Good question, thanks Steve, learnt something new too..
February 10, 2017 at 1:51 am
JasonClark (12/21/2016)
1USE PublishedDatabase
2GO
3EXEC...
December 22, 2016 at 10:59 am
Many thanks for the replies, database owner is sa, there is an entry in event viewer which suggests the login may have changed but not sure how to check...
December 21, 2016 at 3:14 am
After a bit more searching found this link: http://www.sqlservercentral.com/Forums/Topic851583-148-1.aspx which turned out to be the answer in this instance too, should anyone have a similar issue.
December 5, 2016 at 8:10 pm
Thom A (12/5/2016)
Thats not what I was saying, you need to escape the special charaters:
exec xp_cmdshell 'dtexec.exe /F "D:\DBUpdates\Mypackage.dtsx" /SET "\package.Variables[User::JobLoginPassword].Value";"8\:\;xLuZc"'
Many thanks for the clarification, but again after trying several...
December 5, 2016 at 11:13 am
Thom A (12/5/2016)
The escape character for SSIS Expressions is a backslash (\). So, a variable of value; abc"123; would be: ="abc\"123\;".
Thom many thanks for the quick response, however if I...
December 5, 2016 at 5:37 am
Eirikur Eiriksson (11/30/2016)
HappyGeek (11/30/2016)
DBCC TRACESTAUS runs without error.And the output?
😎
Sorry, yes there are no active traces
November 30, 2016 at 4:06 am
Viewing 15 posts - 601 through 615 (of 880 total)