Ok now i know. May be LiteSpeed is not installed there on that server. Can i just migrate those procs into my new server and perform by backups as...

yes they do.

When i explicitly give view definition access on the database it working but i was under assumption that if i give the same access on the server they...

I tried the above query today for my updates and it updated few million records, thenumber which i was looking to update but after the query is not stopped, is...

only events i am interested are

1. Add Login to DB and type of role assigned

2. Delete login in DB or dropped login from the memberrole

Jack

If you want notifications you can do the DDL triggers or you could do a job that queries the default trace on a regular basis which sends you an email...

How would i find unused logins and verify if they owned any objects and then remove them.

is there any script which does all these at once.

thanks

I am using this query to do the job.

SELECT

[TableName] = so.name,

[RowCount] = MAX(si.rows)

FROM

sysobjects so,...

yes i do have permission to delete the files, why?

there is no other instance and also we reboot every weekend.

is there a way i could find the program that is using that file.

I do have litespeed but the database...

I tried moving the files to a different folder assuming that if the database file is in use it will not move and the rest will move so that i...

I am not sure why this is called funny but that is what happening with me.

I trying to know why every time the connection drops to that link server and...

I am collecting trace events by loading the file every 5 min into my own database but i cudnt find exact events when i changed permissions of a group or...

can i write your second query like this...

what do u mean by limit the query. do you want the query to run in batches for select statement.

Hey can someone update my query accordingly to backup partitioned sql 2005 databases.