I'm sorry but I was in a crisis and I haven't too much time to explain, and this issue is some particular.

Right now we have discovered the root cause of...

I think your processor has other speed

http://products.amd.com/pages/opteroncpudetail.aspx?id=644&AspxAutoDetectCookieSupport=1

Could you check and compare the speed of old server core processor and the new one?

I had the same problem in the past and the root cause was the old...

The issue is solved with a workaround, I had to extract data from several tables and the first idea was perform an union query, but I discard that...

http://technet.microsoft.com/en-us/library/bb630446.aspx

Maybe I think SQL had some redo with databases status , I restarted the instance, and then performed a restore database xxx with recovery and worked.

Many thanks for your help.

First option is not available.

Second option doesn't run and fails to update the table.

Thanks

I'm afraid that, but that's the reason to stay in 90 version of databse.

Hi guys,

Please, this setting is already checked from me the server collation Latin1_General_CI_AS.

I think I didn't explain good.

Using the Microsoft standard script to move login between SQL 2000 and SQL...

It's not the case same instances have same collation, thanks

Hi all,

Nice article.

I'm working in a similar trigger but I'm recording information in a table in a Linked server for consolidation issues, because I have several instances and several server...

You must use exec command

CREATE PROC dbo.spMyProc

@Table_Name varchar(50)

AS

declare @command varchar (500)

set @command= 'SELECT * FROM ' + @Table_Name

exec (@command)

Instead a command line, try to put -m on service.

Stop SQL Server service, open properties for the services, in start parameters put -m, try to start.

Try to restore.

When restore is...

Hi,

You can create a new db, and restore old db in it. but you must confirm, tah in restore procces yo change the path and the filename of physical achives...

Normally I use this script to get all user information for a db

select

[Login Type]=

case sp.type

when 'u' then 'WIN'

when 's' then 'SQL'

when 'g' then 'GRP'

end,

convert(char(45),sp.name) as srvLogin,

convert(char(45),sp2.name) as srvRole,

convert(char(25),dbp.name)...