craig-962225 (8/17/2011)

---

If I run a set of SQL statements in SQL management Studio I can return the results of SQL query statements to a grid while getting record counts, print...

You can check the space used by the session that created the tempdb by...

jess. (9/10/2011)

---

I want to drop results from a column

ex:

...where

pi.pay_id = lpa.pay_id and

pi.business_date between '2011-08-14 00:00:00.000' and '2011-08-20 00:00:00.000'

and lpa.name != 'Sched Vac%'

and lpa.name != 'BPay%'

and lpa.name != 'Vacances%'

and lpa.name !=...

query sysjobschedules in msdb database.

In fact i shud write the names too 🙂

Glenn Berry i remember.. but hard to find actual owners for all queries 🙁

I'll write your name at the top of the notepad file;-)

I have done this only one time...

GilaMonster (9/8/2011)

---

ps. (9/8/2011)

---

SQL throws error message...

Thanks for the script Remi. I had written one but this is better. Copied and saved for future use 😉

SQL throws error message for the...

how are u measuring progress? hv you used stats clause in restore? or are you using dmvs?

we've seen orphaned users which are actually windows logins.

sp_help_users_login 'report' doesnt list orphaned windows logins.

you'll hv to write a script to match SIDs bettween database_principals and server_principals.

Thanks Gail.

Is sql denali available for production?

you can create a custom script in vbscript or other scripting language to transfer the files. Sort the files based on modified timestamp so that oldest file is copied first....

You can also use sys.dm_db_session_space_usage DMV to find out which session is using/has used tempdb including IO done in tempdb.