Viewing 15 posts - 1 through 15 (of 18 total)
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...
November 28, 2011 at 5:05 am
I think your processor has other speed
http://products.amd.com/pages/opteroncpudetail.aspx?id=644&AspxAutoDetectCookieSupport=1
November 28, 2011 at 4:54 am
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...
November 26, 2011 at 9:30 am
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...
March 8, 2011 at 12:27 am
February 2, 2011 at 4:24 am
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.
October 4, 2010 at 10:25 am
First option is not available.
Second option doesn't run and fails to update the table.
Thanks
October 4, 2010 at 5:22 am
I'm afraid that, but that's the reason to stay in 90 version of databse.
August 11, 2010 at 2:46 am
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...
April 24, 2010 at 1:32 am
It's not the case same instances have same collation, thanks
April 23, 2010 at 12:33 pm
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...
May 6, 2008 at 7:53 am
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)
November 5, 2007 at 8:54 am
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...
October 30, 2007 at 9:23 am
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...
October 17, 2007 at 9:23 am
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)...
October 17, 2007 at 3:56 am
Viewing 15 posts - 1 through 15 (of 18 total)