hmmm,....never done this before at db level, I've always done somethings in my apps like

...

If Err.Number = 0 Then

do Update

Else

do not Update

End If

What about doing the...

Well, the only case I can reproduce your error, is when I use a GO statement.

I might be mistaken, but after a GO your declaration of the variable is...

Hi roust_m,

quote:

---

I use the following code to record the time my procedure starts

DECLARE @PROC_START_ID int

INSERT INTO pricelist_trace (proc_start_time)

VALUES...

Hi David,

quote:

---

I understand the principle of the above article, I just don't understand how someone could submit the commands to the server...

Hi mehul,

quote:

---

I then changed the owner to a user called mehulshah and then backed up the

database - then i tried to...

Hi John,

quote:

---

problem of 'updates'. I want to somehow know when a row has been updated. I've been reading about triggers, timestamp (rowversion),...

quote:

---

2)

I would also like to drop all those users from the main SQL login.

---

Take...

Hi,

I have the autoshrink option enabled for my user db's. Never had any trouble with this on SQL7. Might be something to consider for the future? How often you do...

Hi Anabel,

quote:

---

I have got a file 5,5 GB and I need to get some space on that server. I have passed registers...

Hi David,

interesting article!

Lesson 1:

True, give the customer one finger they want the whole hand 🙂

Lesson 2:

Maybe the most important of all. Though administrative overkill for the project manager and sometime...

Hi powermad,

quote:

---

Seriously though, you always find users who contact you and say "Oh, I deleted the main list of companies, can you...

Hi John,

we are using Adobe Acrobat to make pdf's. As Andy said it shows up as printer driver. We use it from Excel, Word and Access. It works fine, although...

Hi yp,

quote:

---

One minor thing: Can you guys recommend any good references (web-sites or books) related to date functions and date conversion. I...

Hallo Dieter,

kaum zu glauben, ein weiterer deutscher SQL User. Hurra!!!

Cheers,

Frank

If you are a 'visual developing' kind, Access has some huge advantages. Well, if you compare the table definition screen in EM7 and EM2k you can come to the comclusion,...