ditto

You don't want to always run MAXDOP 1 or MAXDOP 0. There may be queries that cause issues on your system and need modification, but it probably won't be a...

Not that I know of. You can try connecting by IP, port. That might work.

Can you not reconfigure SSRS to point to the new name? Or you don't want to,...

WayneS (1/6/2011)

---

So, is the second part related...

WayneS (1/6/2011)

---

I guess I hit enter... I've PM'd Steve to see if he can take it out, all I can do is edit...

trash

Not as far as I know

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

servername must match the windows name. Sp_dropserver/sp_addserver needed.

Also, you can do a netstat from the command line, and see what port is open and listening. Should be 1433.

Are you not doing a P2V conversion?

Moving to a virtual server is no different than moving to a new physical server. The underlying architecture doesn't really matter to SQL Server....

You don't have failed backups, you have failed jobs. The backup is what is being run, and there will be some data in the job history tables, but the job...

http://msdn.microsoft.com/en-us/library/ms174397.aspx

Start slow Wayne. When I started running every day, I was in decent shape, but concerned about my knees. I went slow, and low, for about 6 months. I kept...

I think Facebook is great. It's a great way to keep in touch with people, see what they are doing, catch pictures, etc. It's an abstraction layer I like, and...

Just came back from a neighborhood meeting. Now I need to go shovel more manure around in my barn.

Does anyone have a fork I can stick in my eye?

Brandie Tarvin (1/5/2011)

---

Is something wrong with me that, as much as I'd like to win a free seat on SQLCruise (RE: Idera's little contest), that it's not incentive enough for...