Viewing 15 posts - 16 through 30 (of 31 total)
great!! thanks 🙂 (now changed on blog)
exactly the type of feedback I was looking to get (+1 karma points for you hehehe)
Thanks again
October 24, 2008 at 11:50 am
does the SQL Error log provide any further assistance?
Is the database in question in a non-usable state? (ie being restored? a mirrored database?, etc)
October 24, 2008 at 11:45 am
I think I might of "out googled" you... lemme know if this is the info you're looking for
( credit: http://www.ngssoftware.com/papers/tp-SQL2000.pdf )
When a user connects to an SQL Server...
October 24, 2008 at 11:27 am
yeah that has been my fall back plan but was hoping that I was missing something to get Upgrade Advisor to work.
Thanks for the replies!!
July 15, 2008 at 2:17 pm
you can't restore a 2005 database (even in 8.0 compatibility mode) to a 2000 instance.
July 15, 2008 at 12:52 pm
Hi Mike
Thanks for the reply but the goal is to automatically save ALL DTS packages as VB .BAS files. In a situation where I have a couple hundred DTS packages...
September 17, 2007 at 7:49 am
hehehe everytime you reply you give me false hope
I've searched the site and have found nothing. I've found similar requests but no answers. ...
September 14, 2007 at 1:47 pm
thanks for the link but if you read the thread in that discussion the suggestions that are made are either manually saving (which is what I'm trying to avoid) or...
September 14, 2007 at 12:10 pm
*bump*
June 12, 2007 at 10:31 am
now what if the statement you are trying to capture is not dynamic SQL but an Update statement that is using parameters.
If I wanted to see the update statement that...
June 7, 2006 at 9:54 am
What if the statement you're trying to catch is within a stored proc and you want to catch it within the same stored proc and log it to a "tracking...
June 7, 2006 at 9:39 am
hmmmm that seems a bit ugly and I might have to go with a dymanic pulling of the statement.
using the tracking table with the individual columns, etc seems a bit...
June 7, 2006 at 9:03 am
Perhaps I misunderstood your solution and how you wanted me to impliment this but this is the results I got when I used the fn_get_sql
So what I have inside my...
June 7, 2006 at 8:39 am
Also I DO NOT want to use an update trigger againt the table
June 7, 2006 at 8:26 am
well I spot checked 10 or so on each server and I think I can say with a decent comfort level that ALL the dts packages are using the "sa"...
May 3, 2005 at 9:37 am
Viewing 15 posts - 16 through 30 (of 31 total)