Viewing 15 posts - 61 through 75 (of 97 total)
Martin Bell (8/2/2009)
the sqlist (7/31/2009)
Mmm... the delete option doesn't seem to work!
What delete option?
I tested that code right before I posted it and everything worked fine.
August 3, 2009 at 10:33 am
I agree with the ideea that the sql script files should be kept in separate files but for the output file is better to have only one as is far...
July 31, 2009 at 10:51 am
I am doing this for a long time now and personally I don't see the need of that complicated T-SQL code. The bacth file is the best and by far...
July 30, 2009 at 3:10 pm
And in regards to the backup-restore promotion method, would work only if the database is in within reasonable size limits, if is few hundred of gigs then becomes a problem.
May 17, 2009 at 8:47 am
Actually you are the one with no structure in place because there is no reason for code in development to be executed in production. When everything is structured and...
May 17, 2009 at 8:42 am
Gift Peddie (5/17/2009)
May 17, 2009 at 8:21 am
Gift Peddie (5/17/2009)
...When you have .bak in VSS that is the only thing given to QA, Staging and production so there is tight control of the database build.
So you say...
May 17, 2009 at 7:58 am
Thanks, Gift Peddie for your reply.
When you say add .bak to VSS do you mean the database backup? Sounds a bit too much, why the need of backup in...
May 17, 2009 at 7:43 am
Gift Peddie (5/16/2009)
May 17, 2009 at 4:46 am
Gift Peddie (5/16/2009)
May 16, 2009 at 9:45 am
JeremyG (5/9/2009)
May 9, 2009 at 4:22 pm
jeremygiaco (4/14/2009)
May 9, 2009 at 8:57 am
You need to use the OSQL utility for 2K server or OSQL or SQLCMD utility for 2K5 server and up. For 2K5 both utility are available. These command line utilities...
April 25, 2009 at 4:10 am
SQL Frenzy (2/25/2008)
Hi,Can we have two identity columns on a single table?
If not then how can one insert an identity column in a table having an identity column?
Regards,
Ahmad
The answer...
April 10, 2009 at 8:07 am
Eric Inman (1/6/2009)
Check this out
http://blogs.msdn.com/queryoptteam/archive/2006/03/24/560396.aspx%5B/quote%5D
The title is "TOP 100 Percent ORDER BY Considered Harmful". My query doesn't use...
January 6, 2009 at 3:02 pm
Viewing 15 posts - 61 through 75 (of 97 total)