Viewing 15 posts - 37,846 through 37,860 (of 49,552 total)
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2009 at 7:19 am
Gift Peddie (7/6/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2009 at 6:04 am
FreeHansje (7/6/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2009 at 4:54 am
Look up PIVOT in Books Online.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2009 at 4:50 am
hi_abhay78 (7/6/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2009 at 1:59 am
Reporting services is running under your credentials and has your old password. So when it tries to log on, it fails with invalid password. 3 or so of those and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2009 at 1:52 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic747530-150-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2009 at 1:51 am
Viewing 15 posts - 37,846 through 37,860 (of 49,552 total)