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
How do I write a hidden trigger against a SQL table?
Answer Question | December 13, 2008 7:48 PM
SQL Server tables, Triggers
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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