SQL 2005 Security to access 2 databases on same server via Stored Procedure
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?
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

bulk update query using sql server
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

Data archiving to additional server
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

Failed ODBC USER DSN connection to 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

SQL 2005 transaction logs
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

DB mirroring with SQL Server 2005: Standard vs. Enterprise
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

Permission to Export SQL Server 2005
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

HOW TO CONNECT VS2005 TO SQL2005
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

Sql Server 2005 ensure columns sum within a table
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

attach a new mdf and ldf files in sql server 2005 enterprise
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

Local clients loose connection to local SQL Server when system network drops connection to HQ.
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

Moving Distribution database from an instance to antother does increase performance ?
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

Running SQL Server 2000 and 2005 simultaneously
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

Adding files to TempDB
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

ASP.NET
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

ASP.NET
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

Multiple rows locked in sqlserver when updating one row
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

Sql server 2005 – query
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

sql server 2005 service will not start
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