If you're using SSMS 2008, there is another neat trick. In the Registered Servers panel, make separate folders for each logical (to you) group. Then, you can right-click the group,...

InfiniteError (11/29/2010)

---

i just need to modify the date modified column, that's all, and nothing else if...

Actually, altering the procedure does not change the create date... you have to drop the procedure,...

xpxj (11/29/2010)

---

167 pgs of instruction for . . .

"The free Microsoft SQL Server Migration Assistant (SSMA) for Oracle speeds the migration process. SSMA for Oracle V4.0 converts Oracle database objects...

Lowell (11/29/2010)

---

InfiniteError (11/29/2010)

---

thanks for the reply

Im sorry i use the sql 2005 keyword, the changes that i want to made is in sql server 2000, i google it and many...

I think the best thing to do would be to generate the csv file through either the OpenRowset function, or via BCP. Then email that file.

By running the query as...

Steve Jones - SSC Editor (11/29/2010)

---

Your job ought to be well documented, ready for inspection, or more likely, ready for someone else in case you get hit by the proverbial...

GSquared (11/29/2010)

---

Wayne, just because a table has an ordered clustered index, doesn't mean an identity column will honor that order. Usually it will, but you can't guarantee it.

Jeff's solution...

Did you try this?

SELECT CustomerNr,

DeliveryWindow = 'Monday ' + MonDeliveryStartTime + '-' + MonDeliveryEndTime +

...

Craig Farrell (11/29/2010)

---

WayneS (11/29/2010)

---

CirquedeSQLeil (11/29/2010)

---

Well, 92 was...

GilaMonster (11/29/2010)

---

More like 'finishing' 🙂

I started working after doing my Hons degree (B.Sc...

CirquedeSQLeil (11/29/2010)

---

Well, 92 was my final year...

GilaMonster (11/29/2010)

---

Not quite sure how to take that. I'm 34 in a week and a day's time....

I think that this link will pretty much give you what you're looking for.

Looks like...