It was removed in 2005, added back in 2008.

I thought Gail was right here. Shouldn't use space for int/char if it's null, the null bitmap should carry that.

I'm not sure what you mean. Is it that Profiler in the SQL Server program group (for SQL Server 2000) isn't working?

It doesn't matter. You can use the SS2K5 version...

You should be able to connect by directly connecting to the port for that instance. So if you have a named instance, you need to set a specific port (port...

Mirroring / clustering the publisher will help you keep things going, but it's a more expensive solution.

What about merge replication? How much data are we talking about and how...

2. use xxxdb go create trigger.

Not sure on #1

FAT32 isn't really designed for large files or heavy activity. I'm actually surprised it's supported in SS2K5

I've updated the links. Some of these broke last year when we migrated platforms and these must have been missed.

I think I did miss my target with the myth, though as I think about it, giving up a liver every day for your boss might be how many of...

You can go dynamic. The SQL Browser service is what determines which port it is if you address the instance by name. So if you have a server named SUIS01...

2000 is the Server network Utility.

Try here: http://www.sqlservercentral.com/Forums/Search1-2-1.aspx

It's likely a transient error. The nHibernate stuff flips out at times. We did have issues this morning, but things seem to be running better now.

Brandie,

I'm slightly buried, but I'll try to get you one in the next week. Got to finish a presentation first 🙁

I think this is a good reason why we should have "certified" applications for SQL Server. Some way to limit access to the server to both a user and an...