I backup my transaction logs at 10 am, 2 pm, 6 pm, and 10 pm, as well as just before the full backup. I use the following code to...

I have restored master several times. Not sure what the -c is for, but I use the -m. I find I must leave the command window open while...

quote:

---

CREATE TABLE [dbo].[AAAATable1] (

[A] [int] NOT NULL ,

 [varchar] (50) NOT NULL ,

[c] [int] NOT NULL)

GO

ALTER TABLE [dbo].[AAAATable1]...

The SQL statement to do this is actually long and tedious, but here is an example I use to do what you want to do:

SELECT intDateID,...

Sorry all, I thought I'd practice my German because (as Frank knows) I will be in Germany starting next weeks for several weeks of temporary military duty. Since it...

Ich weiss jetzt, dass ich gesagt haben sollte:

"Ich gratuliere. Bis mein naechstes EMail..."

Ich versuche immer besser zu sein.

Ron

Frank,

Ich congratuliere. Bis meinem naechsten EMail...

Ron

quote:

---

If you are using temp table inside a stored procedure there is an advantage using a @table instead of #table. The stored...

I guarentee that we are using a trusted connection with our MTS objects. Bottom line: no hardcoded passwords.

quote:

---

For now, if you must have separate boxes for IIS and SQL you either need to go with anonymous or use a...

Good point. I handle nulls in the trigger, but I didn't want to overclutter the answer. Still, your method of handling possible nulls is more elegant than mine,...

How can someone hate triggers? They are a very useful means of maintaining low level data integrity. I have noticed most of the coding examples one finds in...

quote:

---

Secondly, make sure you are using the Properties of the Connection String correctly. I have never seen "Trusted_Connection=Yes".

---

August 4, 2003 at 2:53 pm