Limiting SQL injection in SQL Server 2005
I have a site in ASP and on the back-end in SQL Server 2005, but I keep finding SQL injection on my site. Is there code that will prevent SQL injection from getting onto my site?

Answer Question   |  March 26, 2012  7:39 PM
ASP, SQL injection, SQL Server 2005

Errors while attempting the mirroring process in SQL Server 2005
I am using SQL Server 2005 Enterprise Edition, and I’m having a problem beginning the mirroring process. I am receiving the error messages: “Alter failed for Database ‘db_muthu’. (Microsoft.SqlServer.Smo)” “An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)” “Database Mirroring Transport is disabled in the endpoint configuration. (Microsoft SQL Server, Error: 1486)” What [...]

Answer Question   |  September 10, 2008  7:33 PM
Mirroring, SQL Server 2005, SQL Server Enterprise Edition, SQL Server errors

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

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

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

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

I want to load XML to a table in SQL Server 2005
i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.

Answer Question   |  March 4, 2011  8:58 AM
SQL Server 2005, SQL Server import/export, XML

SQL server – Stocks Data -How to Push Data To Client Application
My client application providing real time stock quotes takes data using a xml webservice which pulls data from sql server 2005.with number of clients increasing for same piece of data, the sql server is being queried again and again.Is there a way to push data from sql 2005 to client application instead of pulling data.Say, [...]

Answer Question   |  August 27, 2008  5:53 AM
ASP.NET, Push technology, Real time, SOA, SQL Server, SQL Server 2005, SQL Server performance, Web development, Web services, XML

What are the benefits of SQL Server 2005 over SQL Server 2000?
If i am satisfied with SQL 2000 then why I should go for SQL 2005

Answer Question   |  August 27, 2008  8:20 AM
SQL Server 2000, SQL Server 2005, SQL Server migration, SQL Server upgrades

Oracle to SQL Server Migration – CURSOR type conversion
When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

Answer Question   |  August 25, 2008  1:42 AM
Database migration, Oracle import/export, SQL Server 2005, SQL Server import/export, SSMA for Oracle

Oracle to SQL Server Migration – User Defined data types
Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

Answer Question   |  August 28, 2008  1:38 AM
Database migration, Oracle import/export, Oracle migration, SQL Server 2005, SQL Server import/export, SSMA for Oracle

Cold Fusion 8.0 + Memory Issues
Hi, I am hosting a cold fusion application which was developed in version 6.1 in CF8 server. There is a application variable which is set to a value of 1000 in the Application.cfm and we invoke components and have a loop till the max value of this variable which runs a sp on SQL Server2005. [...]

Answer Question   |  September 9, 2008  5:37 PM
Cold Fusion, Cold Fusion 8.0, SQL Server 2005

Application compatibility with SQL Server 2005
We would like to upgrade from SQL Server 2000 to SQL Server 2005, but we are currently also using PowerBuilder version 6.0. How can we determine if our version of PowerBuilder is compatible with SQL Server 2005?

Answer Question   |  June 21, 2011  4:18 PM
PowerBuilder, SQL Server 2000, SQL Server 2005

SQL 2005 to .XML
How do I automate 2 sql servers to replicate .xml files

Answer Question   |  August 22, 2008  9:13 AM
SQL Server 2005, SQL Server import/export, SQL Server replication, XML

sql server 2005 slow
Several times during the day SQL Server 2005 Express is becoming very very slow (actually freezes), even if there was no activitry at all. After restart it is normal again for a couple of hours, then freezes again.

Answer Question   |  August 21, 2008  4:02 PM
SQL Server 2005, SQL Server errors, SQL Server Express, SQL Server performance