Recent content by kittyyo

2005. I have never done anything relating to SSIS, but it would be a good time to start. Also the DB is trustworthy on - so I can do filesystem tasks with a CLR without further "activations"? Great! Thanks a lot for your guidance!

As I'm using the German localized version of Windows, the %date% doesn't include any slashes, just dots. :) I considered SQL agent for two reasons: a) The job that creates the file, which I want to rename, is already an SQL agent job (file contains database data). b) I didn't find any suitable...

Hi all! I've been searching for a while, maybe you can help: I need an SQL Server Agent job to rename a file with the original filename + yesterday's date. I figrued out that I should use an Operating System (CmdExec) job step like this ren test.txt test-%date%.txt but I'm stuck with...

You might also look at sp_helprotect http://msdn2.microsoft.com/en-us/library/ms190310.aspx Anne

Hi all! I'm using the PrintDocument class for a printout in my application. In the OnPrintPage event handler, I populate the graphics object using the DrawImage() and DrawString() methods. The document can have up to 140 pages and is printed from the local workstation (a Windows 2000 machine)...

Both servers are set up for mixed mode. Believe it or not: I removed the "run as user" values, and now it works! I would have never thought that! A typical case of overkill... Denny, thanks a lot for solving this issue! [2thumbsup]

The job step is a T/SQL command. I did not use a proxy account, but on the "Advanced" tab of the "Job step properties" window, I set the "Run as user" field. I will mention some other details about the linked server I'm using: I configured the linked server this way: EXEC...

I'm sorry, as it seems I was in an overhast. It appears that the job worked once, but now it does not any more with the same error as before (current security context is not trusted). This is was I did: Since I was not able to change the accounts on the linked server's security tab, I created...

Thank you very much, that was the point! Anne

I'm sorry to bother you with this question - maybe it is really a newbie issue, but I'm new to the SQL Server Agent. I've written a script that calls a stored procedure on a linked server. If I execute this script on the local server, all is doing fine. Then I tried to execute this script...

I found this article on the net: http://www.sommarskog.se/error-handling-I.html Basically it says that messages with a severity smaller than 11 (I think I'm dealing with this kind here) cannot be trapped directly using T-SQL. So if none of you experts has a solution to this issue (I'm still...

Thanks for your answer! Unfortunetely I have to use the message output inside a T-SQL stored procedure. However I now have some more clues on how to search on the Internet about this issue. Anne

Hi, please post the code you are using to create the linked server. Greetings, Anne

Hi all! I've stumbled over a new problem and have not found anything yet on the Internet: I call a stored procedure (by another vendor) this way: DECLARE @return_value int, @AnzahlBenutzer int, @BenutzerSendefehler int, @Fehlerprotokoll nvarchar(max) EXEC @return_value =...

Hi all! Imagine a System.Collections list (e.g. an ArrayList or a HashTable) containing person objects with surnames. If you wanted to search this list for all people whose surname starts with a specific string (e.g. "Sm" when wanting to find "Smith", "Smithers", ...), which System.Collections...