So you think there won't be any issues applying service packs,so no much testing is required like we do for the upgrade right? So i can skip the service pack...

Any advise or ideas?

After running below it worked. Any comments on this?

GRANT CONTROL ON SCHEMA::dbo TO [DBROLE];

GO

Thanks! I created the primary key and then ran the update statement gave an error Access didn't update due to type conversion failure due to key violations.

Thank you

Sorry i didn't get you.

16 is the total memory and 12 is assigned to sql.

Thanks!

Is there a way to capture who and what logins got deleted using the same trigger?

Thanks that helps.

I'm guessing that the "if exists then drop" needs to be there, just like any other database object.

IF TYPE_ID(N'dbo.ColumnTableType') IS NOT NULL

BEGIN

DROP TYPE dbo.ColumnTableType

END

GO

CREATE TYPE dbo.ColumnTableType AS TABLE

(

Column...

The above trigger notifies when there is a new database get's created. However, when the database is restored it won't trigger the alert. Is there a way to add the...

Storage team did not find any issues on their end. Not sure if they are properly looking at their end. If not, do you think it could be a network...

Thanks! Sue. I have to replicate whole database with approx 50 tables to oracle. I can't think of any better option other than SQL Server replication to oracle. If i...

Thanks to everyone!

I agree with Sue!