John Rowan (12/2/2009)

---

Sorry for the delay on this, it kind of fell off my radar. The intent of my last question was to learn which control/data flow tasks you've...

what I want to enhance is :

If a user runs 3 files e.g update.sql ; delete.sql; count.sql

the log file should be update[datetimestamp].txt; delete[datetimestamp].txt; count[datetimestamp].txt

I am able to figure out...

here is what is set up now and is working fine.

There is a folder for each DB server, under...

Hi,

Can you give any example for this or any reference. I have tried implementing logging but it does not take the file name which ran against the database and some...

Thanks Jack,

After I posted, I came across the same post. Let me give a shot ! 🙂

Thanks,

\\K

CANCER (11/29/2009)

---

Can any one help me how to write or include the below scripts in to batch files and run on multiple server to get details...

****************script to get builtin/admin acc...

manikam_sundar (11/16/2009)

---

Hi Friends,

Is it possible to perform Automatic Backups (ex: Daily at 8...

Piotr.Rodak (11/13/2009)

---

I like to write scripts that generate scripts to execute. Please switch SSMS into text mode results and have a look this:

To generate script that will detach databases you...

How about SSIS to achieve this.

e.g. compare...

Thanks for the info....

Can you provide the link for that or any info.

Thanks,

\\K

You can attach the database first and run the script for the logins to recreate them.

Thanks,

\\K

Elliott W (9/22/2009)

---

SQL_Quest-825434 (9/22/2009)

---

Hi,

Can you elaborate...

Hi,

Can you elaborate or give some...

Hi,

You can try this ....

SELECT

t1.resource_type,

'database' = DB_NAME(resource_database_id),

'blk object' = t1.resource_associated_entity_id,

t1.request_mode,

t1.request_session_id,

t2.blocking_session_id,

...