I set up a workload group with a resource pool associated who limits cpu usage to 30 % in a sql 2008 r2 environment.
When I start now 1 session in...
Just set up a Win 2008 ent. sp2 server with sql 2008 r2 ent. with large pages on and traceflag -T834 set. Server has 32 GB RAM, SQL instance...
Want to import data from oracle to sql server 2008 r2.
Therefor I installed oracle instance client (11gr2 x64) on the server.
How to find out with profiler what rights are missing for e specific user?
What kind of events do I have to trace ?
I granted a Domaingroup rights in a DB.
If users from this AD group try to connect they geting the above mentioned error.
(Login failed for...
Does the server (not the client) ever closes a connection to a client cause of inactive session (timeout) ?
We have a central db setup with more applications sharing one instance.
Each application has its one db(s) and AD groups allowing access only...
I have users reporting an error in a application not beeing able to update a specific vaule in a table.
Running a trace gives me the...
On the directories where the Data- (F:.....Data) and the Logfiles (G:....Log) are stored we set up our own access rights (with downward...
If I have the following backup scenario:
Hi all,Have a stored proc that creates three tables and uses these tables in a select within the same sp.
If I create these tables in my db the sp...
After installing sql 2008 I deleted the above mentioned logins.
Now I read that those logins should not be deleted... :-(Is there a way to...
In SSRS 2005 i had a linebar up and running showing the % Free Space of one servers logical disks (y-asis = % free space, x-axis = datetime)...
Just tried to install sql 2005 on a 12 core amd opteron 2431 machine with 4 gb ram.
Setup failes with the following eventlog entry while...
I moved reporting services dbs from 2005 to a newly installed 2008 machine, importet encryption keys and configured ssrs.
(as described here:...
Hi all have a Reportserver and another development machine.
Building a new report on development machine includes building a datasource to my...
Have a Win2008 x64 Machine with sql 2005 x64 sp3 and ssis 2005 installed.
Set up some maintenance plans for backing up db's
All works like...
I just installed sql 2005 ent x64 sp3 and ssis 2008.
When I try to connect to ssis from management studio I get:
Connect to SSIS Service on...
I have a Win 2008 Server with SQL 2005 Ent. x64 sp3.
If I create a AD group login with sysadminrights in sql, the user in this ad group cannot...
I'm looking for a tool that allows the user to show/filter/update/delete/insert data into sql server (2005) tables.
(like access table view,...
Separate names with a comma.