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...

doesn't sound right, as that would require a corrupted database...

lets go back to basics...you dropped some tables...are you sure it was THAT database, and not another database that they were...

terisita i've usually used a server side trace to capture all the DML queries, then order the results on some of the columns in the trace to see whathas high...

another option is to use STUFF to insert 01/20 into the middle of 02/11 to produce 02/01/2011

here's a simple example :

/*--Results:

2/01/2014

12/01/2016

4/01/2023

1/01/2018

12/01/2018

*/

SELECT STUFF(TheFinalResult,CHARINDEX('/',TheFinalResult) + 1,0,'01/20') As TheFinalDate

FROM (

SELECT '2/14'...

there's a large number of scripts in the contribution section for this;

I've used "The Ultimate Duplicate Index Finder" myself;

take a look here:

http://www.sqlservercentral.com/search/?q=duplicate+indexes&t=s

are you including all the custom DLL's your project is referencing?

dlls that are part of the target framework (2.0.3.5,4.0 etc) do not have to be copied local, but any other...

this is how i usually create a role and then add various built in roles to it;

I hope this helps

CREATE ROLE [MyRole]

ALTER AUTHORIZATION ON SCHEMA::[db_ddladmin] TO [MyRole]

ALTER...