You can achive this with the help of Insert trigger on the table where you can log the insert along with a timestamp column.

You can query the triggered table afterwards...

This is not possible.

Run the below mentioned script on both the instances and match the filename and other columns.

select * from sysaltfiles

andy 99843 (10/4/2009)

---

I have a server that crashed due to a backplane failure in a raid-5 setup. When the server came back online the .mdf file was at 0...

Try to check the page file settings ---- are they optimally set???

max & min memory of SQL Server.

Check the excel file if the file has some bulky data\ problem is...

K. Brian Kelley (10/3/2009)

---

You should always try to grant permissions to a role you've created and then put the appropriate users in that role. If you also want the role...

SQL Procedure can also be used.

i.e. you can use textcopy.exe to copy the files.

Pls. provide the Full script of that trigger along with the table structure.

My DB size is around 800 GBs and our...

Hi,

I've done this in my prod. and reporting. Not so difficult, just follow these steps (modify as per your needs)

we take diff backup every night on our prod. so...

Sudeepta (9/3/2009)

---

You have a full backup of size 1GB. Create a database on the QA environment with the same logical file name as of the Production DB. Restore the database...

In SQL Server, FileGroup provides data placement control but if you've created multiple files in a Filegroup SQL will use split and write technique to write simultaneously on all the...

as per my knowledge NO

but you can ask the prod team to export the prod data to new DB of your QA Server.

Damien (9/1/2009)

---

Guys, I really need help badly!!!

We have SQL Server 2000 and it has about 20 DBase on it. My problem is that sometimes my VIEWS on some DBAse...

There are many ways to resolve this:

Ist is try to shrink this DB and then take a fresh backup which can be restored at the destination(QA) Server. [but this can...

This article will help you:

Tracking and Reporting Database Growth

http://www.sqlservercentral.com/articles/Monitoring/66257/[/url]