Create Stored Procedure based upon existing Stored Procedure
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

Is there a built-in stored procedure in SQL Server 2000 that returns the sql table structure of XML format
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

Strange behavior in Access 2003 user interface
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 want to send sap idoc to 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

Migrating SRS reports to new data structure
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

query of query errors
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

SQL Server Upgrade and Server Move
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

Saving Query results into Excel format
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

Move data in SSIS via store procedure
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

Windows 2003 server hangs after reboot
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

Retrieving data from SQL server 2005 using VB6? VB6??
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

BCP and SQL2005 collation issues
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

Oracle Data types
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

sql 2008 system tray icon
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

Email notification in the event of a SQL Server database failover
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

Lacking a FQDN during database mirroring on SQL Server 2005
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

Error message during database mirroring on SQL Server 2005
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

BCP Utility With Additional “INSERT VALUES” Clause
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
BCP Utility

Using MSDE 2000 Release A with my Custom VB 6.0 Application (PDW or Visual Installer 1.1)
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

Creating a website with a SQL Server database
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