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...
Hi all, 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...
Hi all, Want to import data from oracle to sql server 2008 r2. Therefor I installed oracle instance client (11gr2 x64) on the server. Connecting with...
Hi all, How to find out with profiler what rights are missing for e specific user? What kind of events do I have to trace ? TIA acki4711
Hi all, 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...
Hi all, Does the server (not the client) ever closes a connection to a client cause of inactive session (timeout) ? TIA acki
Hi all, 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...
Hi all, 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...
Hi all, On the directories where the Data- (F:.....Data) and the Logfiles (G:....Log) are stored we set up our own access rights (with downward...
Hi all, If I have the following backup scenario: FullBackup1 TransLogBackup1 TransLogBackup2 FullBackup2 TransLogBackup3 TransLogBackup4 Assuming the...
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...
Hi all, 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...
Hi all, 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)...
Hi all, 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...
Hi all, 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...
Hi all, 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...
Hi all, 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...
Hi all, 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.
