You can utilize the schema changes history report available in SSMS (management studio). Within the SSMS UI, right-click the database and/or server name and select the reports option.

You can obtain the runtime and the designer components via the feature pack.

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

NP 🙂 Good luck, be sure to post questions if you run into any trouble 😀

Never heard of it myself 🙂 You can always download trial software from MS as an alternative.

http://www.microsoft.com/sql/downloads/trial-software.mspx

Just FYI - here is a quote from a collegue of mine; MS SQL TS for FL -

"VERITAS VCS is NOT supported by Microsoft. Is you have issues; we...

I'm working for Symantec 🙂 So we are being pushed to "eat our own dog food" if you know what I mean 🙂 My experience has been w/ MSCS exclusively.

You might even consider uninstalling the default instance altogether -

http://support.microsoft.com/kb/909967

From the management studio, right-click the database and/or server in question and select the reports option, and the Schema Changes History report. Here is the T-SQL if you would like...

As George pointed out earlier - either or.

I've been using snapshots in order to provide a static read-only copy of the database for reporting (SSRS/SSAS) w/ great success. Take a look here -

http://www.sqlservercentral.com/Forums/Topic452904-146-1.aspx

How about using OPENROWSET?

OPENROWSET ( 'provider_name'

, { 'datasource' ; 'user_id' ; 'password'

| 'provider_string' }

...

🙂

You need to destroy the object afterwards - sp_OADestroy - i.e.

EXEC @resultcode = sp_OADestroy @ids

if @resultcode = 0

Print 'destroyed object'

You can use an execute SQL task within a ForEach Loop sequence container to populate a couple of int32 variables representing the count and the RowID. SQLIS has a good...

Are you using any SQLDMO ? i.e. sp_OACreate

The SQLDMO connections aren't being destroyed. What build are you running?

Check out TaskManager and look for the PID or Start -> Run -> Services.msc

You should be able to identify the service and follow up w/ your SysAdmin. Both of these...