The problem is in the following select

SELECT iTableFieldId,@iMenuId=iMenuId,@vFieldsName=vFieldsName,@iDataTypeId=iDataTypeId,

@iFieldLength=iFieldLength,@bIsPrimary=bIsPrimary,@bIsIdentity=bIsIdentity,

@bIsNull=bIsNull,@vDefault=vDefault,@bArchive=bArchive

FROM TableField

WHERE iTableFieldId=@iTableFieldId

As the error says, you cannot combine data retrieval...

Dulicate post.

Replies to the following thread please:

http://www.sqlservercentral.com/Forums/Topic561941-8-1.aspx

That's ready for connection, from the point that this message appeared.

2008-09-01 14:38:26.40 spid4 Recovery complete.

What version was the old server? (version and service pack)

What version is...

Could you give us a little more info? The table structure, some sample rows from that table and an example of what you want the result to look like?

What's the messages that it's printed?

Can you connect to it (from sqlcmd running in another command session)?

Is there any other way to get all the logins and user information from...

Not long, but it's not something you should be doing if users are accessing the DB.

Stop the service.

Start SQL in single user mode (takes probably as long as...

Are you doing anything strange to the DB between the saturday diff and the sunday diff?

Generally corruption is a hardware issue (Io subsystem). See -

http://www.sqlskills.com/blogs/paul/2008/08/27/SearchEngineQA26MythsAroundCausingCorruption.aspx

Have you shut the service down? Also make sure that nothing's using the error log file.

Have a look in books online for the procedure to restore the master database, and restore that backup of master. All of your logins and passwords are in there.

It's not...

rbarryyoung (8/31/2008)

The large majority of the reading, writing and caching strategies for hard drives centers on the fact that sequential sector IO's are assumed to be approximately 10x faster than...

Do you have the master database or a backup of the master database?

60 million rows is not beyond SQL's capabilities. I've had more than that in a single table. The design needs to be done carefully, but it is possible.

Are you expecting...

Please don't cross post. It just wastes people's time and fragments replies. Many of us read all of the forums

No replies to this thread please. Direct replies to

http://www.sqlservercentral.com/Forums/Topic561824-149-1.aspx

Very nice.

Just one small thing. You say that for data storage, temp tables are in TempDB and table variables are in memory and tempDB. I may be misunderstanding what you...