Yes.

--Jonathan

Because they were created in the model database?

--Jonathan

I think the real problem is that the schema violates Codd's Information Rule by having identifiers (i.e. table names) connote information. That's why you now need cursors, dynamic SQL,...

You can't use a FOREIGN KEY constraint, but you can create a CHECK constraint with a UDF that references objects in another database.

--Jonathan

quote:

---

But do we need /3GB in the .ini file for window 2000 advanced server?

Thanks

feifei liu

---

You...

Your query would be faster, smaller, and more easily maintained if you put the values in a table and join to that table rather than using a list with IN().

--Jonathan

quote:

---

I didn'tdesign the schema - I inherited it. We do have a members table with a memberid for each person and a...

AFTER is the default behavior, so both your triggers are equivalent.

--Jonathan

You probably haven't given the service account the right to lock pages in memory. Check the local policy.

--Jonathan

We're in the process of hiring another consultant to specialize in financial software. We find it worth something if this person has a CPA (that's the US professional accounting...

Many problems with these scripts:

• Keys can have up to 16 columns. The first script allows only one, the second allows only two.
• Object names need not be regular....

SELECT PARSENAME(REPLACE(Col1,'-','.'),1) txt

FROM YourTable

ORDER BY txt

 

SELECT RIGHT(Col1,CHARINDEX('-',REVERSE(Col1))-1) txt

FROM YourTable

ORDER BY txt

--Jonathan

The easiest way I've found is to use SQL-DMO, but it's not trivial.

--Jonathan

quote:

---

thanks both worked..probably using temp tables was the idea.

There is one more thing

In my other form's query I have

select (col1/col2) as Amt...

First back up the tran log. Restore the most recent full backup with no recovery. Then restore the most recent differential backup with no recovery. Restore the...