Viewing 15 posts - 43,141 through 43,155 (of 49,566 total)
jcrawf02 (11/13/2008)
November 13, 2008 at 9:25 am
Try doing an update usage. On SQL 2000 the space use and space available metadata was sometimes inaccurate. Updateusage will fix that.
DBCC UPDATEUSAGE(< Database name > )
November 13, 2008 at 7:56 am
Updating stats won't change the scan density. That's a measure of how much extent fragmentation there is. Stats just contain the data distribution in the columns.
Try a rebuild instead of...
November 13, 2008 at 7:54 am
The_SQL_DBA (11/13/2008)
Place the tempdb on the RIAD 1+0 to increase throughput. Then the data files on RAID 1+0 also. The backups can go to RAID 5.Thanks!!
How do you propose doing...
November 13, 2008 at 7:49 am
Did you set it to multi-user after syncing the logins and users?
SQL won't just set a DB to single-user, Someone would have had to run a command to do so.
November 13, 2008 at 7:44 am
Post the trigger code please, the table structure a couple of example insert statements and what you want Table_2 to look like afterwards.
November 13, 2008 at 7:36 am
Continued here:
November 13, 2008 at 5:02 am
Not sure I understand you fully.
You have a database on a SQL 2000 server that's giving errors?
Where does SQL express come in here? A different database attached to the 2005...
November 13, 2008 at 5:01 am
You originally posted in in one of the SQL 2005 forums. I asked the moderator to move it.
November 13, 2008 at 4:56 am
That doesn't sound like a login problem. It sounds like a performance problem with that procedure. It doesn't return quickly enough and the front end times out. It may be...
November 13, 2008 at 4:55 am
nazaninahmady_sh (11/13/2008)
i want "Code" automatically increase.
Use an int and make it an identity column.
November 13, 2008 at 4:45 am
Duplicate post.
No replies to this please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic601923-146-1.aspx
November 13, 2008 at 2:48 am
You've got some nasty database corruption there. I don't suppose you have any idea when that started?
I'm not sure how to fix it. Let me see if I can...
November 13, 2008 at 2:15 am
Amit Gupta (11/13/2008)
You should take differential backup and restore it.
Huh? Why would you want to do that?
November 13, 2008 at 2:03 am
I don't think you will be able to restore it with corruption. On the SQL 2000 server, please run the following and post the results.
DBCC CHECKDB(< Database Name > )...
November 13, 2008 at 2:02 am
Viewing 15 posts - 43,141 through 43,155 (of 49,566 total)