Craig Farrell (9/30/2010)

---

CELKO (9/30/2010)

---

Have you even thought about using a relational design instead mimicking a deck of punch cards? Do you know about UPC and industry standards? Do you know...

Remove the comma leaving the space and change the STUFF parameters 1,2 to 1,1 and see what happens.

If your mirror instance and witness are both on Server B and the server itself goes down, you will lose quorum and the principal database(s) on Server A will be...

nadabadan (9/28/2010)

---

CirquedeSQLeil (9/28/2010)

---

You will need to go proc by proc and deny execute to the users.

Another option will be to modify the app so that read type connections are the...

You can also point out the follwing:

Server A -- SQL Server 2005 Standard Edition Principal Server

Server B -- SQL Server 2005 Standard Edition Mirror Server

...

In addition, I think the following code snippet will also help:

declare @FileName varchar(128);

select

@FileName = 'xxx_xxxx.xxx.xxxxx_xxxxxxxx_xxxx' +

'_' + SUBSTRING(CONVERT(varchar(10), getdate(), 10),1,2) +

...

See if the following helps you: http://www.nigelrivett.net/SQLTsql/CheckIfFileExists.html

Check my blog, you'll find some useful date function routines there.

Using SQL Server 200, no WHILE loop required:

DECLARE @test-2 TABLE

(ID INT,

NAM VARCHAR(50));

INSERT INTO @test-2

SELECT 1,'RAM'

UNION ALL

SELECT 1,'PRASAD'

UNION ALL

SELECT 2,'SQL'

UNION ALL

SELECT 2,'SERVER'

UNION ALL

SELECT 2,'CENTRAL'

UNION ALL

SELECT 3,'FAMOUS'

UNION ALL

SELECT 3,'BOOK';

SELECT * FROM...

Triggers would not necessarily be the right way to go. If server B is a failover server, you'd have to disable the triggers on a failover.

Are you trying to...

Possibly, but it would help if you would post the error message you are receiving. I am guessing that when runnng as a job it is running on the...

We have to make some assumptions here since you haven't provided all the necessary details.

Here are my assumptions:

The procedures s1, s2, s3, and s4 are called in sequence. Procedure...

Okay Tom and Bob, I think that is enough. Just agree to disagree and let's move on.

And no, I'm not going to check out the link in that thread...

Paul White NZ (9/22/2010)

---

GilaMonster (9/22/2010)

---

Sometimes I wonder if people think we're posting for our health or something.

<several people>: Change the index thusly

OP: That won't help.

<couple people>: Did you try it?

OP:...

I've terminated an interview when it was obvious the pay was...