I see ... well, then to your question, sadly I do not know then. Compliance is one of those areas I haven't had the pleasure of dealing with.

Best of luck...

My apologies, perhaps I'm still not following ... but If I understand correctly, you want to be able to more or grant deny's on all objects that do not yet...

Bob Fazio (3/11/2008)

---

I know that I can't drop and create the table. Rebuilding of indexes could also cause issues since I know that several users could be sending data...

I do not know much of anything about SOX ... but before you get underway with questions, are you familiar with each recovery model and their purpose? I'm not sure...

So you want to find what schema's do not yet have any permissions to them, so you can then deny access to them? I am pretty familiar with most permissions...

Not entirely sure what you're attempting here ... but this may or may not help point you in the right direction (this will show you a listing of all permissions...

Not sure what it is you're trying to do ...

Schedule a DTS or change the job category of a DTS?

If you're trying to schedule a DTS you have two routes...

This DTS is all focused on this one SQL server yes? Are you connecting to another server at any point? Are you using liked servers or opendatasource at all?

If that...

Developers...

What rights does ics\sqlsrvr have? Is that the account running your...

The Microsoft Jet database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly

The error speaks...

The above is correct, but if you'd like to do it from SSMS:

IF

(

SELECT value FROM sys.configurations

WHERE name = 'show advanced options'

) = 0

BEGIN

EXEC sp_configure 'show advanced options', 1

RECONFIGURE

END

IF

(

SELECT...

The data types char and text are incompatible in the equal to operator

Sounds like a data type was changed and your application no longer works with whatever comparison/join it was...

User does not have permission to perform this operation on table 'T_VBKA_Sales'.

Who is the owner of the job you created? I don't know what you normally do to setup jobs,...

Just the size of the actual clustered index.