Jeff Moden (6/8/2009)

---

Here's one of many problems...

As long as you have the Builtin\Administrators account in SQL Server, anyone who is a member of that role will have SysAdmin access to that instance of SQL Server.

Care to elaborate on the problem a bit? What would really help is and explaination of your code (why the count() over, for one). Also, what is the...

Lowell (6/8/2009)

---

the exact error i got was this:

Msg 513, Level 16, State 0, Line 1

A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement....

GilaMonster (6/8/2009)

---

Tom Brown (6/8/2009)

---

I never did computers at University (Chemical Engineering dept didn't seem to have a use for them back in 1984) So this Big 'O' notation is completely...

GilaMonster (6/8/2009)

---

And...

Lowell (6/8/2009)

---

ok, it looks like two wrongs make a right...NOT combined with [^0-9] ALMOST looks like it works:

CREATE RULE [dbo].[NumericCharsOnly]

AS

@value NOT LIKE '%[^0-9,-+]%'

but the - and + ,...

First, can't cut, paste, and execute the...

Sounds like SQL Server went down hard initially. This means it has to recover the databases to a consistant state. have the database recoveries completed, or are they...

Tara (6/8/2009)

---

something like this where in all the Code column in one server is char(5) and the other is varchar(5)

select h3.code1,h3.code2,h3.code3,h6.code1,h6.code2,h6.code3

from hock3.obever.emp h3 inner join

hock6.obever.emp h6

where h3.code1h6.code1...

A mirror won't do this for you even if you did have a separate server to use, as you can't access the data on a mirror database directly.

Looks like replication...

Could you provide us with the DDL for the tables, sample data for the tables (in a readily consummable format that we can cut, paste, and execute in SSMS), the...

Eralper (6/8/2009)

---

Yes Recursive queries add a lot easiness to the t-sql development.

I had built a recursive split function, a numbers table, etc.

Or you can query on hierarchical data on a...

And send me screaming back to my...

DBASkippack (6/8/2009)

---

Is it possible to update more than 1 column from a 3 way table join?

the following update works when I remove , Col_D = S.Col_D

How can I accomplish...