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
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++
i want to copy the store peocedure from one database to another . iam using sql2005
Answer Question | June 14, 2012 11:11 AM
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
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 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
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
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
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
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
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
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
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
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
Does anyone know how to access sql server wide tables using Access
Answer Question | May 5, 2012 7:01 PM
Access, 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
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
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
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
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