Access via AD group indeed a great approach which will reduce you permission managing if you have several servers.

what is happending if you do manual fail over?.

i dont think it will affect

but add this condition also, hope it will ignore heaps

index_type_desc <> 'HEAP'

agordon 35530 (8/13/2013)

---

Thank you for your reply.

They are all set to grow by 10% and restricted to 15,000 MB.

The log file size will be anywhere from 250 MB to700 MB,...

By any chance your profile is deleted or different option like citrix or other?

the code will work and

yes a group has to be created as a login and then necessary role has to be provided hope these are basic.

Duplicate post

Securityadmin or syadmin is needed to create a login but then they can give permission to any databases.

i dont think there is a option for this.

As chris suggested please post execution plan.

By any change SalesDate table has any indexes if it is on which columns.

in profiler what is the exact thing you miss?

what are the events you tried to find the performance timings?

without code of SP and tables structues involved, no one can suggest...

2TB DB in Simple Recovery Model in local disk , how was the performance?

recently i restored a 1TB backup available from SAN drive to SAN drive took around 4.5 hours....

Securityadmin is a server role which gives access to configure secutiry for server not to database level

refer http://technet.microsoft.com/en-us/library/ms188659(v=sql.100).aspx

assign db_securityadmin for the database.

Oh thanks like older versions i thought it is installed by default.

Is your log file set for autogrowth or restricted to some size?

what is your log file size when the error thrown

what is the log drive size and 15000 MB you...

MichaelDep (8/7/2013)

---

I am connectiing the sam way both on the server and from my workstation. I am using the virtual server name\instance name. When I cannot connect from...