dmc (5/5/2009)

---

I would try my best to avoid the cursor method as well. If the vendor stored procedure is not encrypted, a .net procedure, etc you should be able...

You can create your own auditing with triggers, including DDL and login triggers, in 2005.

Steve Jones - Editor (5/5/2009)

---

I would just run the backup, as Gus noted, but I'd log it somewhere as well, maybe for review the next day. Good to know these...

viswa (5/4/2009)

---

Thanks for reply ...

I am not asking the books.. I need some basic ideas

Why we are going this performance and when we need this performance tools...

When i getting this...

mtassin (5/5/2009)

---

Is there a way to setup a general alert when any database on the system reaches a certain log % full?

I'd love to do this... but I've got 2000...

Lynn Pettis (5/5/2009)

---

I'm thinking that SalesOrder and ReceiptNumber should be reversed allowing SalesOrder to be duplicated. Two receipts for each order. If you make the ReceiptNumber the PRIMARY...

I just tried this:

set nocount on;

if object_id(N'tempdb..#T') is not null

drop table #T;

if object_id(N'tempdb..#T2') is not null

drop table #T2;

create table #T (

ID int identity primary key,

Val int);

insert into #T (Val)

select abs(checksum(newid()))

from...

JohnG (5/5/2009)

---

Jack Corbett (5/5/2009)

---

Jeffrey Williams (5/4/2009)

---

I generally use SET myself - mostly because it prevents issues where you can get the wrong value returned from a SELECT. When using...

He was yelling.

I can honestly claim that I dropped out of both kindergarden and college!

I went to college for 1 quarter. Couldn't stand it.

I'm thinking of going back to get the...

Wow! I don't think I've seen that many significant errors in a script...

MarkusB (5/5/2009)

---

Ok, I stayed away from this thread so far and it looks like it's about a lot of other things not related to the quality of the questions but...

First, your sample data doesn't work. Lynn already pointed out that the PK can't have duplicate values, but the whole idea for this is that you provide a script...

Buy a bigger drive. Or add more drives to the array.

RBarryYoung (5/4/2009)

---

Folks:

I posted my first Microsoft CONNECT suggestion yesterday. It's suggestion #440375 entitled "Add Query-based bulk EXECUTE", you can find it here. Please...