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

Not to worry happy to help

The best solution would be to give the account full control on the disks as this would then follow the best practice of lowest access...

i'm not all that clued up on XML as most of the XML work is done in the apps, not in the DB, so if you could provide a solution...

just done a quick google and it brought back a few results, but i think the social section of MS is offline as I cant connect,

dont know if you want...

=iif(Fields!isYO.Value=0,"not YO","YO")

SSIS/SSRS/SSAS is a cobble together of different development teams using VB.Net and C# (from what I was told in various Microsoft instructor lead courses), so you need to change...

hit the nail on the head, I looked at it and thought, that syntax is right, then thought, doh its not T-SQL its SSRS so gotta use " (speach marks)...

Would want to do something like this

CREATE PROC ............ (@Office CHAR(5),.................)

AS

IF @Office NOT IN ('12','13','14')

BEGIN

SELECT

'Office is not 12,13 or 14'

END

ELSE

BEGIN

SELECT

'Office is either...

this should do the trick

create table #temp (a int, b int, c int, d int, e int, f int)

insert #temp values (21, 45, 11, 16, 567, 1256)

select

convert(varchar,a)+

','+

convert(varchar,b)+

','+

convert(varchar,c)+

','+

convert(varchar,d)+

','+

convert(varchar,e)+

','+

convert(varchar,f)

from

#temp

right, just tried this on our prod server as its externally hosted and we can only use SQL logins as its not tied to the domain

created new DB AntDetachTest

sp_detach_db AntDetachTest

RDP'd...

I have never tried it using a SQL login, to see what actually happens with the file locking, but thats always been the case with Windows logins.

Saying that I will...