Sorry Lowell is that to myself or to Halifaxdal?

halifaxdal (12/8/2011)

---

Works for majority of the sp and fn but throws out some exception:

Msg 4606, Level 16, State 1, Line 1

Granted or revoked privilege EXECUTE is not compatible with object.

Can't...

you wont be able to see anything in the securables section unless you search for a type of database.

i just did the same as Lowell and looked at my test...

you could just do grant execute on database::databasename to rolename if its going to be for all procs in that database forgot about that

edit

ah that works too Lowell, didnt know...

I would loop through the system tables

something like this

SELECT

'GRANT EXECUTE ON '+

obj.name +

' TO RoleName;'

FROM

sysobjects obj

WHERE

xtype = 'p'

Returns a single column, then its just copy and paste into the...

muhammadrazzaqpk-1032285 (12/8/2011)

---

are you guys talking about me being a spamer? I have subscribed for this topic and seeking for help.

This is first time, I have actually replied to any...

that would be due to picking up the mail settings.

you can set the mail settings in the SQL Agent alert system and click ok and think right thats working, but...

update table1 set col1 = ','+col1+','

did you lose an mdf/ndf or the ldf?

if it was mdf/ndf the only option you have is to restore from backup as you have physically lost data.

if it was the...

now it is starting to make more sence,

it may be that we are confusing SQL Mail with SQL Mail, as SQL Mail(xp_sendmail) and SQL Mail as the profile of DB...

please post the create table definition of staging.names and also sample data in the form of insert statments

please see the first link in my signature if you have any problems

did you backup and restore the encryption keys for SSRS as part of the upgrade?

GilaMonster (12/8/2011)

---

anthony.green (12/8/2011)

---

SQL doesnt actually create multiple tables called #temp, it creates a table with a name like the following #h35gddave4, you should be able to see some under TempDB...

table variables are good for a very very small result sets

temp tables are good for all result set sizes

if you call your table #temp, then that table is only visable...

an option using find and replace in SSMS, would be to replace all ' with '+char(39)+' except for the first and last ' so that it looks something like this

create...