• SQL Injection Validation

    HOW CAN I USE VALIDATION CODES IN ORDER TO AVOID SQL INJECTION IN MY WEB SERVER? I MEAN, EVERYBODY KNOW THAT HTML MODIFICATION IS VERY EASY, SO, DO I HAVE TO USE WEB SERVICES TO DO THIS OR GET ANOTHER APP?

    Underworld5 pointsBadges:
  • VB 6, SQL Server 2000 & Crystal Reports

    i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.

    RAYNISH35 pointsBadges:
  • sql server 2000 how can i make backup 4 file only and restore

    how can i make backup 4 file only and restore

    01058478505 pointsBadges:
  • Web Application very slow SQL 2005

    Can I get a detailed information on what are the possible things we can do to identify the performance issues? I had run the SQL 2005 profiler against load test for about 2hrs and captured all the trace. I could see the procedure that runs for various different parameters was consistently taking...

    Jsql155 pointsBadges:
  • Identity Reseed SQL Server 2005

    I have the following table create table SubscriptionTrans ( transid bigint identity(9223372036854775805,1), transdate datetime ) Run the below insert script 3 times. insert into SubscriptionTrans select getdate() You'll get below error Msg 8115, Level 16, State 1, Line 1 Arithmetic overflow error...

    Jsql155 pointsBadges:
  • SQL Server Errors

    Your SQL server installation is either corrupt or has been tampered with (could not open SQLEVN70.RLL0 Please uninstall then re run set up to correct this problem. This question appears in many web pages, but none offers a straighforward method to answer this problem. Reg cure is not the answer, as...

    Tadders5 pointsBadges:
  • sql server 2005 local connection

    I have installed sql server 2005 in local machine and I am trying to connect to that locally. but it is not working. I tried both istalling as default and also by naming as instance. sql server configuration manager shows the services running but I can not connect to in management studio.

    Hashki20 pointsBadges:
  • TSQL error messages

    Is there any equivalent to error_message() in SQL2000?

    Teguma15 pointsBadges:
  • Eliminating Nulls in tSQL

    If I want to return null values in a query that has "Where Field1<>'test' is there an option I can turn on? Example: CREATE TABLE myTable(Field1 varchar(25)) GO INSERT INTO myTable VALUES ('test') INSERT INTO myTable VALUES('test2') INSERT INTO myTable VALUES(null) GO Select * From myTable...

    TJay85 pointsBadges:
  • Deadlock issue in SQL Server 2005

    I have encountered a deadlock issue in <A href="http://searchsqlserver.techtarget.com/topics/0,295493,sid87_tax301323,00.html”>SQL Server 2005</a>. According to the trace flag 1204 report, the following two queries are causing the deadlock: 1. Simple insert statement INSERT INTO...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Being notified when a delete operation is performed on SQL Server

    How can I be notified of delete operations in SQL Server? Is there a tool out there (or something) that will notify me when a user performs a delete operation, without the user knowing about this activity?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL server as data source for OBI EE

    hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but i get following errors when...

    NewIT5 pointsBadges:
  • Formating Sysmessage text

    How does SQl Server generate this error message What happens when an error occurs in a User defined Stored Procedure. Which System stored procedure is fired I know that the error messages are stored in "sysmessages" table in "Master" Database - but which system stored procedure calls this table...

    Teguma15 pointsBadges:
  • Allocated Memory Alert

    Our clients newly installed SBS 2003 R2 is sending out Allocated Memory Alerts. My co-worker says this is common for SBS installations, something to do with SQL Server. He figures we should maybe shut down the SQL service, as it is not in use at this company. I have certainly seen this crop up on...

    AndreaF8,000 pointsBadges:
  • Changing date fields in SQL Server Analysis Services

    In SQL Server Analysis Services, can I change the date fields from (yyyy-mm-dd) to (dd-mm-yyyy) without turning the date field into varchar?

    SQL Server Ask the Experts2,585 pointsBadges:
  • order of evaluation in DateAdd with multiple expressions

    I've spent 3 hours researching how order of evaluation would work in this expression. If @BeginTime was 16:45:00 for example, what would be the result of this expression? set @BeginTime = DateAdd(mi,-Datepart(mi,@BeginTime)-Datepart(hh,@BeginTime)*60,@BeginTime )

    LHalkape15 pointsBadges:
  • Error connecting to a SQL database

    I receive the following errors when I attempt to connect to a SQL Server database on my home computer: 1) Keyword not supported: 'intigreted security'? 2) An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal Reports in vb.net

    iam getting error while making connetion to sql server by OLEDB provider. The error is Sql server does not exit or access is denied ,sqlstate 08001

    Shaz255 pointsBadges:
  • SQL server 2005 to SQL server 2008

    I am following using sql server 2008 but following some lessons written by BOB Taybor. Is MyCompany.mdf for 2005 abailable in 2008 format?

    Standaman15 pointsBadges:
  • windows Server 2003

    Hi, we are in the process of developing an SQL Server-based application for the purposes of monitoring historical server performance and baseline data. Which windows Server 2003 tool and specific data-gathering option would be best suited to obtaining this information?

    Jessie12320 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following