Viewing 15 posts - 4,216 through 4,230 (of 7,504 total)
GilaMonster (12/28/2008)
ALZDBA (12/28/2008)
Try to export the data without these column, so you only lose the text/image stuff if...
December 28, 2008 at 1:41 pm
it has troubles opening your AdventureWorks2008 database.
check your errorlog for e.g.:
2008-12-27 12:03:02.56 spid41s Starting up database 'AdventureWorks2008'.
I would try to get it back up and running...
December 28, 2008 at 1:33 pm
I'll see what I can do ...
I'm not that the office until Jan 5th ...
December 28, 2008 at 9:16 am
- Did you follow best practices by taking a backup before you moved the datafiles ??
- if you did perform a clean shutdown and there weren't any ongoing transactions, you...
December 28, 2008 at 9:02 am
- you should check "c:\program files\microsoft sqlserver 2005\"
there should be a mssql.1 folder, that one contains a file called "errorlog" if you post its content, we may be able to...
December 28, 2008 at 8:54 am
How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005:
- http://msdn.microsoft.com/en-us/library/ms143799(SQL.90).aspx
December 28, 2008 at 8:47 am
also keep in mind you need to enable TCP/IP on your sqlserver instance (server configuration manager) and restart the sqlinstance for it to be able to allow connections over tcp/ip
December 28, 2008 at 8:43 am
even better, BOL now contains more info on DBCC statements then ever !
No yet for all, but for the most of them you'll ever use.
December 28, 2008 at 8:40 am
no doubt about it, you should fix the db in sql2000 !
btw: what service pack are you on (sql2K) ?
Keep a copy of the backup of the corrupted database !...
December 28, 2008 at 8:35 am
it may not only be the left join, but I guess most of the waste time will be the correlated join predicate !
apparently this can be an indexed item, but...
December 24, 2008 at 6:09 am
Well, the instance didn't failover, but it dumped like hell.
SQLErrorlog file stating ".... a lock it does not own .... " which IMO is a symptom for the lock manager...
December 24, 2008 at 4:32 am
bodhilove (12/23/2008)
December 24, 2008 at 4:15 am
What service pack are you on ?
(should be at least SP1, better SP2, best SP3 😉 )
Select @@version
SQL Server 2005 Books Online (November 2008) topic "Monitoring Database Mirroring "...
December 23, 2008 at 2:42 am
Hey.... I've been referenced to :w00t: Thanks Barry 😉
The code is pointed to in the "How to use this article" section !
the word solutions has the hyperlink !....
December 23, 2008 at 2:23 am
Best practice is to keep the scope of a trigger as small as possible.
All executed by a trigger is in the same transaction as the original query (insert/update/delete) !
Meaning,...
December 23, 2008 at 2:15 am
Viewing 15 posts - 4,216 through 4,230 (of 7,504 total)