ok i think i have to use max(date).

thanks

I was just wondering how do i use READ UNCOMMITTED isolation level when i do bulk/fast load using ssis packages, as we have to import our production data (no updates,...

I have the drop down list populated in the report and also my store proc is OK with all the IF statements for parameter values. Now how would i use...

I am looking for a tool that checks hundereds of rules in our scripts automatically and give us a reports for each test case. We do not have a testing...

We also use Quest Spot Light, does it give any such information about number of queries.

My doubt on using this code

The above code will get me row count...

I am trying to do something like this

In the column dbname i would like to have server.dbname and i am doing this way...

(@@servername+db_name())

How can i run the same query to pull data from 30 such databases where in it should also insert a filed with the databasename from where the counts are...

How can i find just the data size in a DB without Log size?

minimum is set to = 0

max is set to = 28672 MB out of 32GB.

right now i set it up to use 80% of the available memory but though there is nothing running on sql server why does full 80% is used, any reason?

Thank you JAmie

I am able to insert a record in the table but i do have 30 such tables to insert 1 record in each which has to query 30...

I have create a table for each database i restore so that i can save counts with timestamp for audit purpose.

CREATE TABLE [dbo].[SIRS_Counts](

Col1 [int] NULL,

Col2 [int] NULL,

Col3 [int] NULL,

Col4 [int]...

I want to report all the counts in a spread sheet with in my backup -restore sql job.

All are full backups and the databases are in simple mode.