Jeff Wood (11/18/2007)

---

Thank you so much. That worked perfectly.

That is a very good question about how did it ever work? The only difference on the systems, is maybe...

Jim Russell (11/19/2007)

---

Another consideration is the source of the data -- the source of our DB data is a mainframe (non-relational) application from which we download biweekly. In that situation,...

MarkusB (11/19/2007)

---

In SQL 2005 you can define DDL_Triggers and Event_notifications to catch these type of actions. See BOL for details.

But even if you haven't defined any of those the...

This is a nice write-up. I know a few folks who could use this. On a related note, how are you moitoring the performance counters outside of SQL Server, such...

If it's SQL Server 2000, there's no better tool than:

dSQLSRVD - dOMNAR's SQL Server SysComments Decryptor

It doesn't work on SQL Server 2005, which requires an admin connection, etc., but it's...

Take a look at the following KB article. Basically, MS has created a stored procedure you'll need to create on your SQL Server. Then, you'll need to execute it via...

In SQL Server 2000 there is no log for this unless you set it up. Depending on your recovery mode, you may be able to use a tool like Apex...

Andy Leonard (SQL Server MVP) and I have blogged about this... a lot. If you go back through the archives of either of our blogs, you should find the cross...

Vescogni (11/16/2007)

---

If I understood the question right I will give you the no no approach I use all the time....

You can search the syscomments tables text value for the name...

I wrote a DTS package like this a long time ago (back in 2001). Basically I used ADO to attempt to make a connection. I then checked the status of...

If you script this, you could use some sort of external timer, say in a Windows service. There's no point dropping and re-establishing the connection every second when you know...

Wow. (pun intended)

I wonder what caused the file to disappear. That seems a bit unusual.

The only thing I've found, which even seems remotely related, is if you've turned on FIPS compliant algorithms. However, that should only affect .NET 1.1 apps and SQL Server 2005...

Any issues with migration should be flagged by the Microsoft SQL Server 2005 Upgrade Advisor (downloadable from Microsoft). If you haven't run it already, you may want to do so.

With...

Actually, if I read your stored procedure right, you don't need to do this. You're taking the EventID being passed in via the parameter @EventID and modifying the row corresponding...