Hello and welcome to the forums. To make it easier for everyone to help, could you please post the following?

1. DDL to create the tables and DML to populate...

Congratulations, Gail. I remember reading a post once where you said that you crossed the 2,000 point boundary. It doesn't...

Jeff and Gail are absolutely right. The list of publishers (as opposed to books) is...

Ring (from the Lord of the Rings)

Sean Lange (12/3/2013)

---

Trestire (12/3/2013)

---

Hi all,

I've files with an unix timestamp as name. For instance filename: 1081277409

I've written a function that based on the filename returns the readable dateformat: 2004-04-06 16:50:09.000

I've...

You're going to need some hefty permissions to use the sp_update_schedule procedure.

http://technet.microsoft.com/en-us/library/ms187354%28v=sql.100%29.aspx

Or you could skip the GUI completely and use the following, changing integer to the data type you need.

ALTER TABLE table_name ADD column_name integer;

http://msdn.microsoft.com/en-us/library/ms190273%28v=sql.100%29.aspx

Dinner 😀

I took an extra look for me as well. Good question - thanks.

There's a pretty cool feature in SSMS that allows you to run a query against multiple instances at the same time and return the results in a single result set....

Access is definitely not my forte and my knowledge is more than a little outdated on it,...

Sean Lange (12/3/2013)

---

Laura_SqlNovice (12/3/2013)

---

Hi Guys,

I need to execute sql server proc from MS Access or Excel... the proc has couple of parameters, but do not have any data comming out....

I also carry a USB drive with me to hold my stuff. And yes...I back it up and don't keep it at work. I guess you could say...

Reuse

Doyouthinkhesarus