TheSQLGuru (8/26/2010)

---

I'm with the guy/gal that recommended using the index usage stats DMV, at least for inserts. And if you have a column that is "always" updated you can...

Lowell (8/26/2010)

---

doh the script i posted was coded for tempdb specifically, this will work in any old database:

SELECT

SCH.schema_id, SCH.[name] AS schema_name, ...

not working for me declare @t table ( id int )

declare @i int ,@top int

set @i =...

@lowell

i am not able to see the required "include column" . i can only see the system related info.

@gail

i tried but couldnt

can u brief about your requirement ?

You can also go for C2 Auditing but be careful, as it increase the overhead on resources.

C2 auditing records information goes beyond server-level events, such as shutdown or restart,...

whenevr we restore any DB ,basically we lose the mapping between login and users which is done by column "sid" , So this columns values should be matched.

select *...

Check this link

http://www.sqlservercentral.com/Forums/Topic570042-5-1.aspx#bm571110

State=16 means that the incoming user does not have permissions to log into the target database. So for example say you create a user FOO and set FOO's default...

I would say, remove the transaction's logic from Sql (database side). because acc to your logic doesnt care about transaction as it is trying to insert data before the Database...

i guess you have added extra quotes. play with single quotes

Thanks to all

DBCC shrinkfile also require space to do the shrinkage

take log backup ( if it is in FULL recovery) then try to do shrinking

if possible , post your query which is being used for migration