Viewing 15 posts - 44,761 through 44,775 (of 49,571 total)
rbarryyoung (9/1/2008)
Of course we use a startup procedure to define the UDT's in TempDB.
Does defining them in model work as well?
September 1, 2008 at 11:41 pm
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 (
...
September 1, 2008 at 5:58 am
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...
September 1, 2008 at 5:44 am
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...
September 1, 2008 at 5:07 am
Dulicate post.
Replies to the following thread please:
September 1, 2008 at 5:06 am
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...
September 1, 2008 at 5:02 am
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?
September 1, 2008 at 4:47 am
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...
September 1, 2008 at 4:35 am
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...
September 1, 2008 at 4:10 am
Are you doing anything strange to the DB between the saturday diff and the sunday diff?
September 1, 2008 at 3:06 am
Generally corruption is a hardware issue (Io subsystem). See -
http://www.sqlskills.com/blogs/paul/2008/08/27/SearchEngineQA26MythsAroundCausingCorruption.aspx
September 1, 2008 at 3:02 am
Have you shut the service down? Also make sure that nothing's using the error log file.
September 1, 2008 at 3:02 am
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...
September 1, 2008 at 1:18 am
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...
September 1, 2008 at 12:14 am
Viewing 15 posts - 44,761 through 44,775 (of 49,571 total)