barry.smallman (10/7/2010)

---

Hi,

Yes, I tried amending the SP to query the sys.dm_exec_connections DMV as suggested in the reply by Lowell!!

When the stored procedure failed to run this morning, I started investigating...

parthi-1705 (10/6/2010)

---

Hi Lowell

why did you changed your pic of old(that dog) it was nice when i came long time...

looks like version 4.2 is for "all" versions of SQL 2008; no special version just for SQL 2008 R2:

there are two different downloads for 2005 vs 2008 though, both marked...

I like to think of SSIS as the universal tool, which can connect to all kinds of datasources, and you can write code to do anything you want. lots of...

SQL has created some ready-to-use Oracle Migration Assistants to make this kind of transformation a lot easier.

http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx

you can do it with SSIS, but this handles a lot of the twists...

post the DDL and sample data here; there's lots of volunteers on...

yogesh_pandey (10/6/2010)

---

Thank you for the reply. But the cur balance is in one table and the transaction is in another. I would have to use cur balance and remember the...

not that easy, because the objectname themselves are not stored anywhere long term as far as SELECT/UPDATE/DELETE are involved; there are some DMV's that keep track of some recent events,...

what you are after is a "Running Total" type of query;

what you end up doing is join the table to itself with an alias , by offsetting one row to...

not sure if this is what you are after;

Peso is one of the forum members with a strong grasp on this;

there is a thread about Dijkstra's Shortest Path Algorithm, which...

barry can you edit the procedure? I would add a simple but detailed auditstatement to dump the snippet below into a table in master or call sp_send_dbmail, so you could...

Derrick Smith (10/5/2010)

---

Wait, we need "reasons" for this kind of...

select * from sys.objects where name like 'queue_messages%'

select * from sys.tables where name like 'queue_messages%'

they are tables,...

bump, as I wanted to know if kras followed up on the reasoning behind wanting to drop the production database.

sysInternals Contig.exe allows you to defrag specific folders, file specs like *.mdf or even specific files form a command line...so it's a little faster operation to script out the...