Ninja's_RGR'us (9/21/2011)

---

NJ-DBA (9/21/2011)

---

Henrico Bekker (9/21/2011)

---

try using the following:

use master

go

SELECT

percent_complete AS ‘PctComplete’,

start_time AS ‘StartTime’,

command...

Henrico Bekker (9/21/2011)

---

try using the following:

use master

go

SELECT

percent_complete AS ‘PctComplete’,

start_time AS ‘StartTime’,

command AS ‘Command’,...

Anchelin (9/21/2011)

---

Hi All

I need to sent reports via Database Mail to specific people.

My scripts looks like the following; below script rename and move to another directory (they want to have...

I went with "answer past Questions of the Day on SSC"....

Ninja's_RGR'us (9/20/2011)

---

NJ-DBA (9/20/2011)

---

jared-709193 (9/20/2011)

---

I still believe that we are missing a bigger issue here. We are developers/admins who work within an interface that executes script very easily. We...

jared-709193 (9/20/2011)

---

I still believe that we are missing a bigger issue here. We are developers/admins who work within an interface that executes script very easily. We can all...

the one thing I would caution about using a dummy database is to watch out for GO statements...

for example, if you have

USE dummydb

select * from sys.objects

GO

select * from...

His question was answered- he said he "did not want to debug, just execute...

that...

Not saying this is the best way, but it's the way I deal with it... I always avoid having to deal with variable file names by using logic like:

1 find...

mxhxr (9/20/2011)

---

Do you always wait until after-hours to deploy a stored procedure or function to a production system? Is there any risk of a quick DROP/CREATE of a proc...

Hi Sarah,

Saw this when you first posted and didnt respond because I'm not sure, but my thought is that the process spawned at the OS level is constantly grabbing more...

ramyours2003 (9/20/2011)

---

i created login to add AD group in sql , i want to give dbo permissions...

sporoy (9/20/2011)

---

Your bet was right.. Somebody has given all database level permissions to public role and guest user (there is no guest role, its a user but not mapped to...

You can enclose the whole block of code in comments like:

/***

my code

line 2

**/

Then it can only run when highlighted.

My bet: some of your developers have the nasty habit of granting permissions to groups like public or datareader.

run the following against your database to enumerate object level permissions ,...