Viewing 15 posts - 181 through 195 (of 219 total)
pg53 (1/21/2010)
Apart from that, what's going on with the transaction? ... that rollback in the middle - can you do that?
You can roll back a transaction in the middle, in...
January 21, 2010 at 8:38 am
sjimmo (1/21/2010)
but 2005 and earlier, the default is 2MB for data with a 1MB T-Log, giving you a total size of 3MB
For MSSQL 2000, the default size of model's MDF...
January 21, 2010 at 8:17 am
Let me make a guess 🙂
The main purpose of QODs is education.
For most QODs it is education of the community, but for some QODs it is education of the question...
January 21, 2010 at 3:31 am
Hugo Kornelis (1/21/2010)
The documentation on CREATE DATABASE is here: http://technet.microsoft.com/en-us/library/ms176061.aspx.The default log file size is only given in one of the examples (unless I overlooked something)
It is given in the...
January 21, 2010 at 3:20 am
mzz3lh (1/20/2010)
(1 row(s) affected)
(1 row(s) affected)
this is an exception
Msg 208, Level 16, State 0, Line 10
Invalid object name...
January 20, 2010 at 3:11 am
Hugo Kornelis (1/19/2010)
I was not able to find the maximum number of full-text indexes per table. (I'm still hoping someone else finds this and posts a link).
Here it is: http://msdn.microsoft.com/en-us/library/ms187317.aspx
CREATE...
January 20, 2010 at 12:45 am
f_ernestog (1/19/2010)
January 19, 2010 at 6:43 am
Hugo Kornelis (1/19/2010)
Up to 1 clustered index, up to 999 nonclustered indexes, and up to 999 XML indexes (http://msdn.microsoft.com/en-us/library/ms143432.aspx), plus a number of full-text indexes...
January 19, 2010 at 1:23 am
Jedak (1/18/2010)
I've written a ton of DTS packages
I wrote only two or three when I was preparing to MCP exams, so I have a very brief experience in this area...
January 18, 2010 at 9:29 am
Jedak (1/14/2010)
if you used the .NET SQLClient as the driver the parameters would probably need to use the @ sign as that is how that provider works?
MSDN says that...
January 18, 2010 at 4:41 am
sknox (1/11/2010)
January 12, 2010 at 1:30 am
skjoldtc (12/30/2009)
Is this a bug in SQL Server? Why would an instance that is not part of replication cause this behavior when removed?
The referenced article applies to SQL Server 2000...
December 30, 2009 at 7:35 am
If I change the variables to anything from float(25) to float(53), I get the wrong answer (75.42)
What's the relation between this value and the values from the question (165.755, 165.555)?!
If...
December 30, 2009 at 1:40 am
I clicked on the link...
...and I saw that the article 'apllies to Microsoft SQL Server 2000 Standard Edition'. Does it apply to SQL Server 2005, 2008, or even MSSQL...
December 29, 2009 at 1:24 am
Ref: Save Transaction - ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/b953c3f1-f96d-42f1-95a2-30e314292b35.htm
Rollback Transaction - ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/6882c5bc-ff74-476a-984b-164aeb036c66.htm
Some people don't have BOL2008 installed 🙂
These links fit better:
Save Transaction - http://msdn.microsoft.com/en-us/library/ms188378.aspx
Rollback Transaction - http://msdn.microsoft.com/en-us/library/ms181299.aspx
December 22, 2009 at 12:57 am
Viewing 15 posts - 181 through 195 (of 219 total)