but you can always make another...

Can you post some data?

refer to this link

http://www.sqlservercentral.com/articles/Best+Practices/61537/

You can use the data in master..sysprocesses, make a stored procedure schedule it to run lets say every 3-5 min then sends you a report or alerts you via email...

bard (8/5/2008)

CREATE PROCEDURE [so_name]

@imgcount int,@Photo varchar(55),@Col Varchar(10),@ExpID int

AS

Declare @SQL varchar(500)

set @sql=''

select @sql='UPDATE Experience SET [' + @Col + ']=['+@Photo+']'

select @sql=@SQL + ' WHERE ID='

select...

I think you can use sp_who2 or values in the master..sysprocesses table You can view the host pc, program name, db name accessed by the hostname etc.

Did you try BCP out to a text file then BULK INSERT to a table?

Sobrang tuwa ahhh 😀

@vambati

if the conditions below apply i think you can use the script even if the backup is .dmp extension

1. MSSQL 2000

2. Backup Process is a "Native SQL Backup"

-...

avipenina (7/31/2008)

---

Lester Policarpio (7/31/2008)

---

Sorry for the late reply 'm so busy in my work. Maybe i can do something to modify the script. What do you want? different location for...

vambati (7/30/2008)

---

It is said this will work for .BAK files...can this be used for .dmp files as well and can anyone help me with that...i have 200 db's to migrate...

Sorry for the late reply 'm so busy in my work. Maybe i can do something to modify the script. What do you want? different location for mdf and ldf...

How about using the BULK INSERT command (can be viewed in BOL)?

Is this what you want??

DECLARE @dbname varchar(255),@query varchar(255)

DECLARE dbname CURSOR FOR

select name from master..sysdatabases where dbid > 6

OPEN dbname

FETCH NEXT FROM dbname INTO @dbname

WHILE(@@FETCH_STATUS = 0)

BEGIN

SET @query = 'SELECT '+@dbname+',...

Did you try using OPENROWSET?

I also have a setting of generating automated reports (daily). What i used is OPENROWSET to load the data from mssql to excel. As for the...

This is what I used for monitoring the servers

1. Data and Logs

DBCC SQLPERF(logspace) - For Logs

DBCC SHOWFILESTATS - For Data

2. Database Backups

You can use the data in msdb database, backupset...