Sounds like a plan to me. I couldn't, it's been so long I just barely remember anything beyond 3NF,...

The terms being used almost makes it sound like class work in a Modeling class.

panwar.jt (6/24/2009)

---

I am using following command

DECLARE @FileName varchar(50),

@bcpCommand varchar(2000)

SET @FileName = REPLACE('c:\authors_'+CONVERT(char(8),GETDATE(),1)+'.txt','/','-')

SET @bcpCommand = 'bcp "SELECT * FROM [demo2_rmps]..mms_menu " queryout...

Look up these roles in Books Online (BOL)

SQLAgentUserRole

SQLAgentReaderRole

SQLAgentOperatorRole

Supposedly, according to Books Online, the following should tell you:

select serverproperty('LicenseType')

Problem is when I run it on systems where I know the license mode of the servers I get DISABLED...

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