Viewing 15 posts - 3,061 through 3,075 (of 3,221 total)
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...
June 27, 2008 at 4:36 pm
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
June 27, 2008 at 3:28 pm
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...
June 27, 2008 at 1:16 pm
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
June 27, 2008 at 11:06 am
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...
June 27, 2008 at 9:59 am
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...
June 26, 2008 at 3:26 pm
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...
June 26, 2008 at 7:54 am
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...
June 25, 2008 at 11:36 am
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/
June 25, 2008 at 11:15 am
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...
June 25, 2008 at 10:42 am
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 -
Books
Pk ISB
Author
Title
Publish date
Publish date
(refer to above link...
June 24, 2008 at 7:33 pm
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?
June 24, 2008 at 6:04 pm
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...
June 24, 2008 at 12:07 pm
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...
June 23, 2008 at 4:43 pm
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...
June 23, 2008 at 3:41 pm
Viewing 15 posts - 3,061 through 3,075 (of 3,221 total)