Hi,

I have same problem with 2008 R2. Have you found a other soltion than remove and add again the user

I have modified the script for removing and for improving the compatibility.....

USE [master]

GO

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

/**

********* 03/26/2008 - Luke Campbell - uspIndexMaintenance.

This procedure reorganizes any indexes (NON XML)...

have you a parameter for the compression level with 'litespeed'? And is it compatible with sql server 2008 ?

Thanks

Excellent you are a real guru.......

Some info

IF PERMISSIONS()&2=2

CREATE TABLE test_table (col1 INT)

ELSE

PRINT 'ERROR: The current user cannot create a table.'

--------

This example determines whether the current user can

grant the...

Thank a lot for your response. Sometimes, I have some users who are in several groups in the Active directory ....

With this mothode I see only main group

Thank...

I was the solution,

select * from sysobjects where (OBJECTPROPERTY(id, N'ExecIsStartup') = 1)

Thank a lot ........

Thank i understand now sorry

It seems easy, but it is not case on my database. Perhaps I do a bad manipulation somewhere. I create a user by the enterprise manager and...

in the hotfix 1078, MS change 'xp_log70.dll.' to xpsql70.dll'

also the solution :

exec sp_dropextendedproc 'xp_cmdshell'

exec sp_addextendedproc 'xp_cmdshell','xpsql70.dll'

exec xp_cmdshell 'dir *.exe'

and it worked OK.

If you have a explain for that ......It...

I tried as login Sa but I have the same error message

Server: Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'xp_cmdshell'.

Also, I saw...

I tried as login Sa but I have the same error message

Server: Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'xp_cmdshell'.

How to change the default owner? For example, I would change for user “tata” with owner bruprod by default. In fact, when the user makes a query,...

in our sql 7 sp2

connect with:"bruprod"

select *

from catTitles

ok

in our sql 7 sp4(other server)

connect with: "bruprod"

select *

from catTitles

not work "Invalid object"

but

select *

from bruprod.catTitles

ok ?

I do...

example:

Work sql 7 sp 2 but not sp4.

Setuser ‘bruprod’

Go

Sp_recompine ‘CatTitles’

Go