Viewing 15 posts - 37,861 through 37,875 (of 49,569 total)
DECLARE @dt SMALLDATETIME
SET @dt = '2009/01/01'
SELECT YEAR(@dt)
SELECT DATEPART(yy,@dt)
July 6, 2009 at 9:56 am
The log file won't help at all and you're better off removing the second log file.
The second filegroup may help if the server was IO bottlenecked and if the new...
July 6, 2009 at 9:34 am
river (7/6/2009)
I have then, tried to restore on 2000, and i could not do the operation.
You won't. Databases cannot be downgraded.
July 6, 2009 at 7:53 am
river (7/6/2009)
If i have a backup from SQL Server 2005, is there any possibility of restoring it no SQL server 2000?
No. A SQL 2005 database is in the SQL 2005...
July 6, 2009 at 7:33 am
You're running SQL 2005 RTM. The logon trigger was added in SQL 2005 SP2. You need to install at least SP2 (recommended SP3) to be able to create login triggers.
July 6, 2009 at 7:28 am
Lynn Pettis (7/6/2009)
2NF - The Whole Key -- Shouldn't Product and Category be split at this point?
Could be, but we don't know if Name (the only non-key attribute that we've...
July 6, 2009 at 7:19 am
Gift Peddie (7/6/2009)
July 6, 2009 at 6:34 am
Brandie Tarvin (7/6/2009)
That third party tool will not interfere with the SQL Server native backup chain. And the backup chain will not interfere with the third party tool's chain.
If the...
July 6, 2009 at 6:04 am
FreeHansje (7/6/2009)
July 6, 2009 at 4:54 am
Look up PIVOT in Books Online.
July 6, 2009 at 4:50 am
hi_abhay78 (7/6/2009)
July 6, 2009 at 4:42 am
The Inside SQL Server series are excellent, they however are not beginners books. If you're looking for something a bit more beginners, T-SQL fundamentals by Itzik Ben-Gan is excellent.
July 6, 2009 at 2:20 am
As I said...
To fix that, your select max needs a more restrictive lock. Updlock is the one usually used. That however is going to hurt concurrency.
Why are you insisting on...
July 6, 2009 at 2:15 am
Sorry, not sure what you're asking.
If it's the cause of these, problems with the IO subsystem. I cannot be more specific as any form of problem with any portion of...
July 6, 2009 at 2:04 am
Gino (7/5/2009)
I didn't get the errors prior to the upgrade:
The reason you didn't get errors before the update is that on SQL 2000, checkDB does not run checkcatalog and very...
July 6, 2009 at 1:59 am
Viewing 15 posts - 37,861 through 37,875 (of 49,569 total)