a quick reply...

create or search a script that works on SQL Server 2000 which will give out the object permissions for each user. Run this script on SQL 2005 after...

Hi

sp_change_users maps a login to a user. By itself it will not generate user permissions. Have u transferred the users from your SQL 2000 db to SQL 2005 db?...

Very good article.

Couple of things i would like to know about the update statement with output clause. What type of locks would be involved with update statement and how to...

check this out

http://www.sqlservercentral.com/articles/deadlock/64315/

I think you need to investigate why you have long running transactions.

I store sensitive information encrypting it from the business layer and into a varbinary/varchar column.

Why not SSIS

😀

Any issue with using the maintenance plans in sql server.

Why every 5 mins?

krypto69 (9/30/2009)

---

This is for ad-hoc reporting and is one big 'flat table'.

So, I never know what fields they could pick, they could pick any or all of the 400 columns.

Long...

Just curious...

"Configuration option 'max server memory (MB)' changed from 2147483647 to 6144. Run the RECONFIGURE statement to install"

If 6144 is your max memory what is your min server memory?

Doing a shrink operation on production db in working hours is not recommended. You need to find out when your db is least used and do it then.

Log files...

thanks for sharing this.

r u able to send mails other than database mails from the mail server ?