How do I create a Stored Procedure based upon an existing stored Procedure in SQL Query Analyzer V 8.00.760
Answer Question | September 8, 2008 6:31 PM
SQL Query Analyzer, SQL Query Analyzer 8.x, Stored Procedures
i have a xml file.i want to insert the contents of the xml file into a table in sql server 2005.
Answer Question | September 8, 2008 5:33 AM
SQL Server 2000, SQL Server import/export, XML
I create a form in access 2k3 data project connected to sql server 2k5. I put two check boxes on my form. On runtime, when i click on one of check box, it also fires on the other check box…set check box value from false to true. But it works normally when i use keyboard [...]
Answer Question | October 17, 2008 11:27 AM
Access 2003, Access forms, Microsoft Access, SQL Server 2005
I have one application in sap which takes sap data into idoc and want to send in sql server 2005
Answer Question | September 8, 2008 9:49 AM
iDoc, SAP IDocs, SQL Server 2005
I’m migrating to a new database with different tables and fields but want to continue to use the SQL SRS reports that I previously had (there are hundreds of them). Is anyone aware of a tool that will allow me to map the new and old data structure and update the rdl files for SRS?
Answer Question | September 28, 2008 10:59 PM
RDL, SQL, SRS
I have a runtime query of a query error as below. java.lang.String cannot be cast to java.util.Date But the output format is correct and is in date. This application was developed in coldfusion 6.1 and sqlserver2000. But now we get this error when it was migrated to coldfusion 8 and sql server 2005. Below is [...]
Answer Question | September 9, 2008 5:11 PM
ColdFusion, ColdFusion 6.x, ColdFusion 8.x, Java, Java applications, SQL Server 2000, SQL Server 2005
I have an old Windows 2000 server running SQL 2000 and need to retire the server and move my SQL databases to a new server. The new server is a fresh install of Windows Server 2003 and SQL Server 2005. I am having a hard time finding a procedure for this complex conversion. Is this [...]
Answer Question | September 11, 2008 3:23 PM
SQL Database, SQL Server 2000, SQL Server 2005, SQL Server upgrades, Windows 2000 Server, Windows Server 2003
How can I save query results into .xls format directly from Microsoft SQL server Management studio?
Answer Question | September 5, 2008 1:43 AM
Microsoft Excel, SQL Server 2005, SQL Server import/export
How do I set up an SSIS pkg to move results from a stored procedure from an external ss2005 db to the local ss2005db?
Answer Question | September 5, 2008 10:14 PM
Import external data, SSIS, Stored Procedures
Hi All, We have a Windows 2003 server ( Model: HP Proliant DL385 ) running SQL Server 2000, in which we always experience issues. The issue is that Windows Server 2003 hangs after every reboot. Sometimes, it has also bluescreened and has created a memory dump. First time, when it bluescreened, the memory dump points [...]
Answer Question | September 6, 2008 7:36 PM
Event ID 5719, Event ID 5783, Event ID 770, HP ProLiant DL385, SQL Server 2000, Windows Server 2003
How to create an application in VB6 that can retrive data from microsoft SQL Server2005.Is that possible.Thank you.
Answer Question | October 7, 2009 7:14 AM
SQL Server 2005, VB, Visual Basic
I get this error: Error = [Microsoft][SQL Native Client]Unable to resolve column level collations SQLState = 01000, NativeError = 5701 I am using the standar collation that comes with SQL2005
Answer Question | September 3, 2008 3:54 AM
BCP Utility, Bulk Copy Program, SQL Server 2005
I am just learning an ORACLE 9i Book and i was seen that in number Data type the Range is Lies between 1 to 38 in Decimal And -84 to 127 of Scale Range How it is possible because these Fraction degits are subtratect from whole degits ex:- var1 number (5,25);--------------(1)--it is possible? var2 number [...]
Answer Question | September 3, 2008 9:30 PM
Data Types, Oracle 9i
how can i add a system tray icon for sql 2008 just like sql 2000?
Answer Question | September 28, 2009 8:31 PM
SQL Server 2000, SQL Server 2008
In case of a failover of a SQL Server database, I’d like to be notified by email. Can you tell me how to activate this option?
Answer Question | September 3, 2008 7:04 PM
Failover, SQL Server database
I am trying to work with database mirroring on SQL Server 2005, and I keep receiving the error message, “One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.” I know that the syntax for a fully-qualified TCP address [...]
Answer Question | September 2, 2008 6:59 PM
Database mirroring, FQDN, SQL Server 2005, SQL Server errors, TCP
I am trying to begin database mirroring in SQL Server 2005. I have Service Pack 2 installed, and I have three instances running. When I attempt to start mirroring, I receive the error message, “One or more of the server network addresses lacks a fully qualified domain name.” My network addresses are: TCP://Joe:5024 principal TCP://Joe:5025 [...]
Answer Question | September 3, 2008 5:47 PM
Database mirroring, SQL Server 2005, SQL Server errors
I’ve nested 23 separate BCP commands into a single BAT file. Each BCP command pulls data from a separate text file and inserts the data into a single table. Here’s the kicker, when inspecting the newly inserted rows in the table, I need to be able to associate each row with the BCP command that [...]
Answer Question | September 12, 2008 5:43 PM
Hello IT Pro, Please can anyone give a thorough guideline on how to package my VB 6.0 Application with MSDE 2000 (Also including my Custom Database) so that my clients gets the CD and install without my being there for assistance Please help
Answer Question | September 2, 2008 1:57 PM
MSDE 2000, PDW, VB, VB 6, Visual Installer
What programming tools can I use to create a website that will be hosted on a Windows-based platform with a SQL Server database?
Answer Question | August 29, 2008 4:01 PM
SQL Server database