The Knowledge base article on "How to transfer logins and passwords between instances of SQL Server" has been updated and now includes how tos for different versions of SQL Server.

http://support.microsoft.com/kb/246133

Thanks Gift and I understand your point.

When I was young and first making the transition from IBM mainframes to Unix/Windows environment and a customer told me that the RDBMS was...

Additional comments:

The SQL Standard allows multiple triggers on a table for the same action

and allows specification of the order with the SEQUENCE keyword but

SQL Server allows multiple triggers but...

The trigger source you posted adheres to the SQL Standard but is not supported by SQL Server,

which uses a TransAct/SQL dialect. This is understandable, as SQL Server Triggers predate...

Gift Peddie wrote

That is the thing you have skipped creating the ER design before converting the ER design to the relational tables still does not include RDBMS vendors.

And...

I am not sure what you are trying to say, but SQL in todays world is being looked as a powerful development tool.

It would not be correct to say that...

I own many database design books, and recommend either of these two.

College course reference and tends to the theoretical:

Handbook of Relational Database Design

by C. C. Fleming and Barbara von...

Back to the original question about the SQL Server debugger. My question is why would one ever use such a tool? I have been writing SQL since 1990...

"Would this type of Index affect the performance of inserts?"

As Gail Shaw indicated, there are many factors to answer this question and two that should be answered first are:

1)...

"Its not a bug its just bad practice."

Default databases are a bad practice. About a year ago, I went thru a review with the Security and Auditing department...

Sorry, a correction:

Customers database is restored first and is assigned dbid of 5 and then the Products database is restored and is assigned a dbid of 6.

The dbids of 1...

Setting the Default database to anything other than master is asking for trouble as you discovered. The root cause is that within the logins system table, the default database is...

Based on the IO statistics, it appears that the table has very few rows which causes the optimal SQL query plan to be a table scan via the clustered...

It is unclear what you attempting to do with names like Table1 and Table2, but why is the solution so complex?

This SQL appears to be a logic equivalent:

delete from...

Be aware that the default configuration of SQL Server 2008 does not allow connect from a different computer. Use the SQL Server Configuration Manager to configure allowed network protocols.