Need 1433, TCP open. 1434 UDP if looking for instances.

I haven't done this, but in my understanding, you can install in English and add the database, table, or even just the columns that you need to support a particular...

How is it inserting them? It appears that something is trying to show a dialog box.

I have separate databases, but there is no reason you cannot have them in one. SQL Server supports multiple schemas. The terminology here is "owner" instead of "schema". You can...

There are some times when EM is performing some actions, like reindex, etc. where it will  freeze until the action is complete. I've seen this happen when connecting to a...

Yes you can. These are completely recorded in the log. Bulk changes are only recorded at a gross level, the page level I think, so you can't recover to an...

Curious why you htink 2048 is more manageable?

To do this, if you have free space, you can execute a dbcc shrinkfile to lower the size of the existing databases. I'd...

I agree with Bill. Shrink after reindex.

http://www.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp

http://www.sqlservercentral.com/columnists/awarren/usingthecopydatabasewizard.asp

http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp

You can also use CHARINDEX to find the place where the underscore is and take a substring up to that point.

Apparently I can't win.

Those who mentioned CE or MSDE, you are overthinking the question. It isn't meant to trick you, but to test your knowledge. I would have assumed that...

At first glance, I'm thinking dynamic sql is the other way, but I might be interetsed in 12 procedures instead. Not like they'd change that often.

Having a Beta group is a possibility. we've talked about it, but it adds overhead for us to somehow get the question out to people, and have them answer it....

It should be able to be done if you are backing up everything iwth the product. You can also backup the data with Veritas (or anything else) and the logs...

If you can compose and deliver and HTML email, many systems use a small 1x1 pixel white image to track reads. They create a few million unique ones, mail the...