Can two separate cursors update the same SQL table when executed together?
I have three tables. Table One is a master table which contains rows which need to be updated with data from the other two tables (I’ll call them Table Two and Table Three). I have created a cursor which updates existing rows in Table One with data from Table Two. This works fine, and following [...]

Answer Question   |  March 23, 2011  10:57 AM
SQL Cursors, SQL Server 2005, SQL Server 2005 administration, SQL tables

Trouble installing SQL Server 2005
I have installed SQL2005 as default instance on a server that already has 2000 as the default. how can I remove sql2005 safely and reinstall 2005 as a named server.

Answer Question   |  September 9, 2010  8:06 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Installation, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2005 administration

Running Profiler, an update statement show reads but no writes?
Example: last 3 columns are write, rowcount,reads [table] [tbody] [tr] [td]75072[/td] [td]SQL:StmtCompleted[/td] [td]UPDATE UserHdr SET LastActivity = ’29-Aug-2010 01:23:24 AM’ WHERE UserKey = ‘M’[/td] [td]205[/td] [td]2010-08-29 01:23:24.393[/td] [td]The FactorSoft Program[/td] [td]12695[/td] [td]2010-08-29 01:23:24.407[/td] [td]0[/td] [td]1[/td] [td]2[/td] [/tr] [/tbody] [/table]

Answer Question   |  September 7, 2010  2:16 PM
SQL 2005, SQL Profiler, SQL Server 2005, SQL Server 2005 administration, UPDATE statement

Calling stored procedure in a database to query data in another database
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]

Answer Question   |  February 14, 2012  3:20 PM
SQL 2005, SQL Query, SQL Select, SQL Server, SQL Server 2005, SQL Server 2005 administration, SQL Server stored procedures, T-SQL

error in creating new database using sql server
I enter as the administrator, and when creating a new database a message always appear stating that permission denied in database master! what shall i do?

Answer Question   |  March 1, 2012  3:36 AM
SQL Server, SQL Server 2005, SQL Server 2005 administration, SQL Server 2005 error messages

SQL Server 2005 System Report
I need some ideas of how to create a SQL Server System Report, i.e. how much memory has been consumed, how much time was taken in a job run? Can some one provide me an example, please? Thanx.

Answer Question   |  May 15, 2010  4:40 PM
SQL Server 2005 administration, SQL Server 2005 Analysis Services, SQL Server 2005 Reporting Services

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

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

SQL Server Reporting services
I am trying to add a field that has different values.I need to add them to get a total number .Example: Lesson num field contains value 1245,3467,6754,9987,4089 I need to add them to get a total of 5.

Answer Question   |  April 8, 2010  1:32 AM
SQL Server, SQL Server 2005 administration, SSRS 2005, SSRS reports

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

Fulltext Search – SQL Server 2005 SP2
I am new to the SQL Server 2005 Fulltext search technology and I have not tried it yet myself. I would like to ask about availability of a feature which is provided for example by the Oracle Text technology which is indexing documents using FTP protocol. I have various formats of text documents residing on [...]

Answer Question   |  May 16, 2009  9:57 AM
FTP Server, SQL Server 2005, SQL Server 2005 administration, SQL Server Full Text Search

How to check Max Worker Threads in SQL Server 2005
We’ve had a few performance incidents in SQL Server 2005 and I want to check the Max Worker Threads. Would someone explain how to return that? Thanks. Moderator Note: This is a user submitted question

Answer Question   |  March 21, 2009  7:08 PM
Max Worker Threads, SQL Server 2005, SQL Server 2005 administration, SQL Server 2005 performance

SQL Server 2005 Memory
My SQL 2005 Enterprise Edition SP1 on server 2003 Enterprise SP2 has 12GB memory. I set min memory 10MB,10GB for max memory and set ‘lock page on memory’, but Task Manager show only 4.50GB only and performance monitor show SQL server manager – total memory on 4GB. Expert: Do I setup memory wrong?

Answer Question   |  March 9, 2009  10:46 PM
SQL Server 2005 administration, SQL Server 2005 memory, SQL Server 2005 performance