Changes in stored procedures from SQL Server 2000 to SQL Server 2005
If you could, could you please give a list of the relevant changes that have been done to stored procedures from SQL Server 2000 to SQL Server 2005?

Answer Question   |  December 10, 2008  7:52 PM
SQL Server 2005, SQL Server migration, SQL Server stored procedures

Writing a hidden trigger against a SQL table
How do I write a hidden trigger against a SQL table?

Answer Question   |  December 13, 2008  7:48 PM
SQL Server tables, Triggers

Uninstalling a SQL Server service pack
If we have problems after installing a SQL Server service pack, can we uninstall it with no issues?

Answer Question   |  December 11, 2008  7:47 PM
Service packs, SQL Server, SQL Server Service Packs, SQL Server upgrades

Running SSIS on a clustered server with SQL Server 2005
We are using SQL Server 2005, 64-bit, on a Windows 2003 clustered server with Active/Passive ‘A’ and ‘B’ nodes. Databases are on a shared LUN. I can run all my SQL Server Integration Services packages on the ‘A’ node with no problem. When we fail over to the ‘B’ node, though, packages are failing. I [...]

Answer Question   |  January 28, 2009  7:47 PM
Clustered servers, SQL Server 2005, SQL Server Integration Services

Error message from SQL Server 2000 Agent after antivirus installation
SQL Server 2000 Agent would not start after the installation of the antivirus software Sophos and a reboot. I found the messaging service was shut off, so I started it, rebooted and the agent came up running. I then tried to start a backup job, but I received “error 14258,” which stated that it was [...]

Answer Question   |  December 11, 2008  7:44 PM
SQL Server 2000, SQL Server Agent, SQL Server errors

Finding which columns contain data in a table
I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table [...]

Answer Question   |  December 10, 2008  3:42 PM
columns, Data migration, Database migration, Oracle Database, Oracle Database to SQL Database Migration, SQL Database

SQL Stored Procedure
I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.

Answer Question   |  December 19, 2008  2:50 PM
iSeries, ODBC, SQL, SQL stored procedures

insert into with select and passing variables
This is driving me NUTZ —- SQL Server 2005 and PHP the variable :t_id is being passed from other pages and works in other statements, but is not parsing within this statement. If I replace :t_id with say 30, it works just fine. I tried declaring a new variable and passing it to the statement, [...]

Answer Question   |  December 11, 2008  2:21 PM
PHP, SQL Server 2005, SQL Server errors, SQL Server Variables

Consolidating SQL Server databases
How I can consolidate seven SQL Server 2000 and SQL Server 2005 databases to only SQL Server 2005 databases? Both servers are HP and Dell servers.

Answer Question   |  December 10, 2008  9:09 PM
SQL Server 2000, SQL Server 2005, SQL Server Database Consolidation, SQL Server databases

Connecting to SQL Server from an Oracle procedure
We need to pull data from a SQL Server database, and our database is Oracle. How would I connect to SQL Server from an Oracle procedure?

Answer Question   |  December 9, 2008  9:08 PM
Oracle, SQL Server database

Estimated cost for upgrade from SQL Server 2005 SE to SQL Server 2005 EE
What is the estimated cost to upgrade from Microsoft SQL Server 2005 Standard Edition to Microsoft SQL Server 2005 Enterprise Edition?

Answer Question   |  December 10, 2008  9:06 PM
SQL Server 2005, SQL Server upgrades

SQL Server 2000 script
Hi , How can we use SQL 2000 script to call 2nd maximum date? case : Item A has few price with different effective_date, Ihow can i call an item’s price with second max(effective_date). Thanks in advance.

Answer Question   |  December 11, 2008  10:31 AM
Conditional SQL statements, SQL, SQL Query, SQL Server 2000, SQL Server 2000 Scripts, SQL Server Scripts

Migrating data from Microsoft Access to SQL Server 2000
I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.

Answer Question   |  December 9, 2008  8:00 AM
Database migration, Microsoft Access, Microsoft Access import/export, SQL Server 2000, SQL Server 2000 import/export, SQL Server import/export, Windows Services

Writing a report drawing information from a SQL Server 2005 table
I am writing a simple report that displays records from our customer table, a table that has no corresponding records in our contacts table. My code entered in SQL Server 2005 is as follows: select contractor.name,acctstatus, statusDetail, sales_person, loggedInBy,loginDate, lastUpdateBy, LastUpdateOn from contractor where contractor.name NOT IN (Select company_name from leads_contacts) I keep getting an [...]

Answer Question   |  December 8, 2008  7:25 PM
SQL Server 2005, SQL Server tables

Error message when installing SQL Server 2005
I have installed SQL Server 2005 and acquired SP2. However, when I continue to install the SAP dialog instance, it gives me the following error: MDB-05036 Error when creating sqldmo SqlServer object What does this mean?

Answer Question   |  March 8, 2011  6:02 PM
SQL Server 2005, SQL Server errors, SQL Server installation

EMC Network Backup Client/Agent backup for SQL 2000/2005 databases on Polyserve Matrix
Hi, I am new with running SQL 2000/2005 instances on Polyserve Matrix servers. We use EMC Network as a corporate backup strategy. Can someone tell me will there be any problems using this backup tool for SQL instances on the Polyserve Matrix?

Answer Question   |  December 8, 2008  10:17 AM
Backup, EMC backup, HP PolyServe Matrix Server, PolyServe Matrix Server, SQL Server 2000, SQL Server 2000 backup, SQL Server 2005, SQL Server 2005 backup, SQL Server backup

Transform Data task properties not opening.
In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.

Answer Question   |  March 10, 2009  6:34 AM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task

SQL error. There is already an object named ‘InitCap2′ in the database.
I am running the following code in Microsoft SQL Server Management Studio Express, and after I run it, I get the following error, even though it is returning the record set that I am looking for. I would like to get rid of this error. Thanks. The error is: Msg 2714, Level 16, State 5, [...]

Answer Question   |  December 5, 2008  8:21 PM
InitCap2, SQL, SQL Server errors, SQL Server Management Studio, SQL Server Management Studio Express

Unreported error in an order entry application designed in SQL
I have developed an order entry application in SQL Server for a client. One of its functions is to insert invoices into the relevant tables. The procedure only does the job 997 times out of 1000 on average. In a single day, that means that hundreds of invoices are incomplete. No errors are reported, no [...]

Answer Question   |  January 9, 2009  6:43 PM
SQL Server stored procedures, SQL Server tables

Figuring out the SA password in order to upgrade to SQL Server 2005
I am upgrading my firm’s legal software to a version that uses SQL Server 2005. We are on a Windows 2003 Small Business Server, and SQL Server was installed before I started at this firm. My new software needs me to login as the System Administrator. I cannot seem to do that, as I do [...]

Answer Question   |  December 24, 2008  6:38 PM
SBS 2003, Small Business Server 2003, SQL Server 2005, SQL Server administration, SQL Server upgrades, System administrator