I'd be happy to join if there is space yet. Thanks!

Nice work, thank you!

Steve-

I think that more and more the lines between personal life and work for workers in IT are getting blurred as technology advances. And I also think that it can...

I try to stay off that sort of thing as much as I can. Never at work, and at home sparingly. However, I have been on it quite a bit...

Thanks for that...not sure why I didn['t find it. Must not have looked ahard enough. Anyway, if you request 6 from MS, you'll get 7. Thanks!

I am thankful for my coworkers. The guys and gals in our IT department are a great bunch of smart asses that can always get our job done. Very casual...

SQLServerCentral has given me over the years has been critical in my career. Here's why. I was a Systems Engineer for a bank and we were getting bought out. I...

Maybe another interesting take to throw out there: Seems we have been talking mostly about user db's. What about system db's?

I know that I have had to restore the system...

Depends on if you are using Enterprise Manager  or Management Stuido as your tool. In EM it is located under Tools|option. In 2k5's MS ist is located under both the...

Actually there is a better way under the TOOLS|OPTIONS menu click the results tab. Change the results target to 'Reuslts to file..'  and Results output format to CSV.

When you run...

The MDF's and LDF' s should not be in use when the SQL server service is stopped. I agree that you should defrag physical files in addition to the indexes...

I have never had the opportunity to work from home, but my take on it would be this: It would be pretty cool during the school year but exteremely difficult...

Steve-

Thansk for the response. I am able to successfully load the xml documents into a xml data type column.  I guess my question is now, what is the best method...

Vandy-

Greg is correct; as  we currently have a linked server connection to an AS400 and it works well in my environment. Let me know if you have any issue setting...

We are getting a new server with 2k5 for reporting services. Our other servers will remain 2k for the foreseeable future.Like you mentioned our current implementations are rock solid;...