Does defining them in model work as well?

It should, yes.

In sql 2005 and higher, Top 100% ... order by is only honoured if it is in the outermost select statement.

This will return in random order

SELECT * FROM (

...

thatok (9/1/2008)

I have a table IRchair which has columns staffno and clusterid. I am going to add to this table a clumn named period. So I need to bring...

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...