We are tyring to apply best security practices by only granting EXECUTE security to Stored Procedures connected to a Role and make users members of the role. However the SP needs to access data from another DB on the same server and when trying we receive “SELECT permission was denied on the object”. We have [...]
Answer Question | April 16, 2010 8:33 PM
Database management, Security, SQL 2005, SQL Server 2005, Windows Server 2003
When does SQL performance start being affected by the size? We are running SQL 2005 64bit on Windows 2003 Enterprise 64 bit server. The database is over 1 tb. When does MS SQL start to degrade with database size?
Answer Question | April 12, 2010 2:17 PM
sql 2005 Performance Issues, SQL Server 2005, SQL Server 2005 (64-bit), SQL Server 2005 Enterprise Manager
Hi , We need a way using sql server for updating more than one rows at a time . Thanks , Pramod.
Answer Question | April 13, 2010 8:01 AM
SQL Server 2005, SQL Server 2005 administration, SQL Server 2005 Database
We have two identical SQL Server 2005 databases. We need to archive data to another server over a network. What would be the best way to accomplish this? This is primarily required because data needs to be archived for at least five years. We don’t need the archive server for backup purposes, just for archiving [...]
Answer Question | April 12, 2010 6:15 PM
Data archiving, SQL Server 2005
I developed a project in VB.net with SQL Server as the backend using ODBC Data source. I converted the DB to SQL Server 2005 and tried to change the ODBC Data source connection with a SQL Server native client. The ODBC USER DSN connection is not obtaining the SQL Server 2005 database I created. How [...]
Answer Question | January 20, 2012 4:00 PM
SQL Server 2005, VB.NET
At what point should we truncate the transaction log
Answer Question | April 9, 2010 1:38 AM
sql 2005 Performance Issues, SQL Server 2005, SQL Server 2005 administration, SQL transaction logs
On the subject of database mirroring in SQL Server 2005… Besides snapshot access and high safety mode having to be on, as well as the redo thread count, are there any other limitations placed on mirroring, utilizing Standard edition vs. Enterprise edition? I was under the assumption that to allow automatic failover, Enterprise edition was [...]
Answer Question | March 31, 2010 10:21 PM
SQL Server, SQL Server 2005, SQL Server Database Mirroring
On SQL Server 2005, what is the minimum permission needed to allow a user to export tables from one database server to another server? Permission on SOURCE=? Permission on DESTINATION=?
Answer Question | April 9, 2010 7:55 PM
SQL Server 2005, SQL Server 2005 administration, SQL Server permissions
Dear sir, how to connect vs2005 to sql2005 and which setting do in vs2005 and sql2005
Answer Question | March 29, 2010 3:59 AM
SQL, SQL Server 2005, Visual Studio 2005
how can i ensure the total sum of 5 columns within the same table equals 100 during insert or update in SQL Server 2005?
Answer Question | March 29, 2010 11:47 PM
SQL, SQL Server 2005
i have a new mdf and ldf file created in sql server 2000.how could i attach these to sql server 2005 enterprise edition?i tried it by right click the database and select attach.but it shows an error when click the add button in database dialogue box.
Answer Question | March 26, 2010 6:45 PM
LDF, MDF, SQL Server 2000, SQL Server 2005, SQL Server 2005 Enterprise Edition
When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database. For some clients, the application still works just fine. The clients are all set up and authenticated in the local Domain Controller. It is my thought that the authentication [...]
Answer Question | March 19, 2010 9:14 PM
Active Directory, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, VB
The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some collisions between users (through application) and the [...]
Answer Question | March 15, 2010 10:49 AM
distrib.exe, Performance/Tuning, SQL Server 2005, SQL Server Performance Monitoring, transaction replication
When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?
Answer Question | March 12, 2010 6:51 PM
Performance/Tuning, SQL Server 2000, SQL Server 2005
Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?
Answer Question | March 11, 2010 6:41 PM
SQL, SQL Server 2005, TempDBs
i have four textboxes abd a database whicjh is already created. what i want to do is if i enter the value in the four textboxes and press button it should automatically gets updated or saved in the database.
Answer Question | March 10, 2010 4:52 PM
ASP.NET, SQL Server 2005, Visual Studio
i want to insert the data into the existing database
Answer Question | March 10, 2010 4:13 PM
ASP.NET, SQL Server 2005, Visual Studio
In Microsoft SQLServer, I found out that when you perform an SQL update, in a lot of cases multiple rows are locked, even when row-locking is configured for that table and page-locking is prohibited, and even when you force row-locking in the SQL statement using WITH (ROWLOCK).
Answer Question | March 9, 2010 9:03 AM
SQL Server, SQL Server 2005, SQL Server 2008
How to write quary to calculate second highest salary in Emp Table using “Top” Keyword
Answer Question | February 25, 2010 6:39 AM
SQL Server 2005, SQL Server Query
I have a new server running server running windows 2003 and sql server 2005. when I turn on allow remote connections and restart sql service the service fails to start. If I turn off allow remote connections the sql service starts with no problems. I have been unable to find any potential solution to this [...]
Answer Question | May 26, 2011 10:16 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity