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...

you cant, you can only get the hash value as passwords are encrypted.

one thing you could do is to get the encryption method SQL uses to store password, then pass...

You could also use the RAISERROR keyword to raise errors on different error ids and severities.

Can you send screenshot of your alert configuration and the lines from the SQL error...

This user has done it on a number of topics now and is getting quite annoying, I have gone through the...

you will have to build a query into like the following to suit the tables, this is just knocked up

SELECT

'ALTER LOGIN '+

user.username+

' WITH PASSWORD = ''£!@123AVeryStrongPasswordGoesHere321@!£''

FROM

sys.sysusers user

This will then bring...

Thanks yarizus for sumarizing the topic.

Just one thing, why did you detail SQL Mail, surely you mean DB Mail? This is SQL 2008 and SQL Mail is now a...