This is an error whereby, the result query (SELECT * FROM X) has given

more data than there is memory available in the system to handle.

Either that, or look...

Make use of somehting like:

DECLARE @sql VARCHAR(1000) SELECT @sql = 'exec ' + @servername + '.' +

@databasename+ '.dbo.sp_executesql N''grant select on '+ @tablename + ' to '

+ @username...

You can make use of xp_regread and xp_regwrite stored procedures to do this but I don't think its recommended. These procs. will directly make update in the registry.

You need to...

The Bulk-Logged model provides higher performance and lower log space consumption for certain large-scale operations (for example, create index or bulk copy). It does this at the expense of some...

Is this SQL Server instance clustered?

MJ

Try this:

if ((SELECT count(name) FROM master.dbo.sysdatabases) - (select count(*) from dbo.Historique )) <> '0'

begin

...

Adding to what Steve and Shaw said you have first track down the code involved in deadlock and then you need to change the code or tune the code to...

I saw the below mentioned explanation somewhere on this site:

SP4 reports queries blocking on themselves?

What you are seeing is not related to locks, rather it is related to the

latch...

You can't go for mirroring here as it is a feature in 2005 and also the mirror database is not avvailable for access until failover happens.

Either go for backup/restore as...

Seems like you might have something listening on TCP port configured for this instance or might be its blocked somehow.

Do you have more than one SQL Server instance on...

To find objects owned by specific logins use:

select user_name(uid) as OwnerName,so.name as ObjectName from dbo.sysobjects so where uid<>user_id('dbo')

And to change the owner back to dbo or any other user...

Have you specified the file extension explicitly under the maintenance plan? For example, file with extension ".BAK"

MJ

You might need to uninstall\install .NET framework again.

MJ

Have you set SET NOCOUNT ON in the beginning of stored procedure?

Did you ran the stored procedure just after running it in QA?

MJ

Try this:

ALTER USER user_name WITH LOGIN = login_name

MJ