Each user who will access the sever will need a CAL. All it really is, is a piece of paper that tells you how many users can access the...

imSQrLy (4/24/2009)

---

I have created a sproc that calls xp_cmdshell to install sql server. The full script(only posting the install part here) then does some other stuff like create data and...

Did some reading myself on this subject and found basically the same thing you did. The following is from BOL:

Restrictions

On a 32-bit system, database mirroring can support a maximum...

slimtonone (4/1/2009)

---

Please help trying to run the below script to export to a txt file, on my local servers they work, generated the files fine, im local admin on the...

I know it has been quite awhile since you posted this question, and I was wondering two things. First, were you able to resolve the issue or is it...

knight (6/26/2009)

---

ahhh... i think i got it... can't concatenate inside the variable of a SP, or function.... i guess i'll just wait for any confirmations....

have to set a new...

I have to agree, you came here and asked for help. Proper forum etiquette, even if you solved the problem...

Heres a solution I have thrown together:

CREATE table dbo.tbl_prescription_dates (

Prescription_id int,

Date_Issued datetime)

--The Data to populate the table is:

INSERT INTO dbo.tbl_prescription_dates (Prescription_id, Date_Issued)

SELECT 1, getdate()

UNION ALL SELECT 1, DATEADD(d,-1,getdate())

UNION ALL...

Glad to hear that. Wold you mind showing us how you resolved your problem?

If, at the time of failure you still have access to the server and the transaction log, that is when you do a tail backup of the log file. ...

sreekirt (6/22/2009)

---

My requirement is similar to it.

But i need to compare two column from two different tables.

I should be able to insert into table1 only when col1 >= col1 of...

Here is another option that won't use a triangular join and scales quite well:

CREATE TABLE dbo.EMPP

(EMPNO INT,

ENAME VARCHAR(20),

SAL INT,

DEPTNO INT

)

INSERT INTO dbo.EMPP

SELECT 7840,'MANISH',2000,10

UNION ALL

SELECT 7399,'GAYLE',3000,10

UNION ALL

SELECT 5389,'SIDHU',7000,20

UNION ALL

SELECT 7690,'ARVIND',3000,20

UNION ALL

SELECT...

You really only need one of those indexes from what I can see. That would be the one that includes all the columns listed in the INCLUDED column lists....

Went back to Slave Boy's thread just now, and I'm wondering, is it just me or do some posts just magically appear where I hadn't seen them before?? This...

I'd go with the EXCEPT as well, you just have to be sure that both queries have the same number oc columns and that they are the ones you want...