Think this might stir your thoughts but how about.

1. Create the database - without data in any tables

2. Detach the database from your server instance.

3. Copy the...

Please supply more data. Refer to link in my signature. Supply complete error statement including error number, state and text and then maybe we can help

Since a view is created using a SQL statement and that the table or one of the tables utilized in the view has had a column deleted or the column...

thuybi

More than likely it is a typographical error, for example the following is missing the ) directly after the asterik

select grp,subgrp,

count(* OVER

Should be

select grp,subgrp,

count(*)OVER

That's certainly a good way to describe it! Although this particular behavior is laid out in ANSI's definition, it's certainly not incredibly well documented elsewhere (and not mentioned per...

Darn good question.

Between the database setting of Allow_snapshot_isolation, all the Row versioning techniques / abilities, then throw in the MSDB for good measure. Now I think I know how...

Many times questions are more important than answers, since they lead you to search by yourself... and you usually learn much more from that search than from the answer itself...

When I composed this question my objective was to:

Anyway I realized that "cloning" has a different meaning here, so my answer was clearly wrong.. at least I learned something new...

For using Excel and SQL Server might I suggest this article which I found to be extremely informative and as a bonus includes sample code

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

Start here:

http://www.microsoft.com/events/default.mspx

and then work your way through the various topics. Using this I have found over 100 downloadable webcasts / virtual labs with sample code on SQL Server 2005...

Please read: ... http://www.sqlservercentral.com/articles/Best+Practices/61537/

Please note that your books table appears to have two columns with the same column name -

(refer to above link...

Please read: ... http://www.sqlservercentral.com/articles/Best+Practices/61537/

Following the above best practices will help us help you.

This appears to be a cross posting of

http://www.sqlservercentral.com/Forums/Topic522558-145-1.aspx#bm522906

Is it?

Refer to this

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

to set startup options - Be sure to review each item in that Environment window - think some of it will do what you want. Note...

Completely off the wall and not a T-SQL solution, but an idea that may spark something additional.

1. Create a 46th db.

2. Have the application open that db when...

For an extensive course in how to use SQL Server Management Studio (SSMS) and I mean extensive

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

For a short quickie

Open SSMS

Connect to a server

1. In top tool bar select...