Answer Questions

• HowardRichards SQL Injection

  Am looking for SQL injection automation tool,can anybody suggest a tool which will be helpful. You might try referring to http://www.sqlsecurity.com in this case where you might get some information in thsi regard. Oh, ok. Didn't knew something like this existed. Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Hi, What do you mean with a tool SQL injection is for doing malicious stuff with a DB. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Hi, Yes you are right, but to test such malicious stuff i need some automation, where you can just enter the required thing and the tool should do the rest of the things, such as manipulati ...Show All

• Martin Schmidt Help with SQL

  I have a table named "policy_details" having four columns called policy_details(varchar),effectdate(datetime),Historyid(int) and policy_status(varchar). I want to keep only the maximum historyid records in "policy_details" where policy_details and effectdate should be equal and policy_status should be '30240084' . I want to delete the remaining records where policy_details and effectdate should be equal and policy_status should be '30240084'. Cheers Praveen Interesting, when I write the following query, which is almost exactly like yours: begin transaction DELETE FROM person.address WHERE ROW_NUMBER() OVER ( PARTITION BY addressId ORDER BY addressLi ...Show All

• HSCSydney Wmi Error 0x80041003 in "SQL Server Configuration Manager"

  Hello, When I logon as a non-admin user & start the "SQL Configuration Manager", I get a WMI Error 0x80041003 when I try to add an alias. When I try to delete an alias, no error is shown, but the alias is not deleted. When I logon as an admin user, everything works fine, so this looks like a permissions problem. (AFAIK, 0x80041003 means "permission denied". ) I already ran the WMIDiag tool, this reports that WMI config is fine (but WMIdiag needs admin permissions to run...) Any ideas which WMI permissions are needed to run the SQL Configuration Manager as a non-admin user Thanks in advance for any suggestions.. I think Admin privielges are required by defa ...Show All

• Siteadm Scripting unattended install in a batch-file

  Hi! I'm trying to do the following in a batch-file: 1) Install SQLExpress unattended providing settings in an .ini-file 2) Run an osql-command which creates a database and some tables etc. My batch-script looks like the following: REM Install SQLExpress start /wait .\SQLExpress\setup.exe /qb /settings %CD%\mysettings.ini osql -S (local)\MyExpress -U sa -P passwd -i .\createdb.sql ... The problem is that the SQLExpress setup updates the %PATH%, but the change is not visible in my cmd-context . So, the osql-command fails. It seems like I have to start a new cmd-window from the windows shell to get the updated environment. Is there any way to make the environment changes visible to my script This might be m ...Show All

• xyzt update

  hi i cant use update like this. how set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo] . [tt] AS BEGIN SET NOCOUNT ON ; DECLARE @t1 TABLE ( a int , b int , c int ) DECLARE @t2 TABLE ( a int , b int , c int ) insert into @t1 select a , b , c from table_1 where a = 1 insert into @t2 select a , b , c from table_1 update table_1 set c = @t1 . c where ( @t2 . b = @t1 . b ) END You logic is missing some things. What if two values will evaluate from the join It would be something like this: UPDATE table_1 Set c = @t1.c FROM Table_1 t1 CROSS JOIN @t1 INNER JOIN @t2 ON @t1.b = @t2.b HTH, Jens K. Suessmeyer. -- ...Show All

• Jimmy Koo Removing protected beta files

  I cannot install SQL SErver 2005 because of files still on my hard disk from beta version. These include sqlmgmprovider.dll and svrenumapi.dll. The uninstall program is no longer available. How do I get rid of whatever remains of the old beta installation so that the released version of SQL Server 2005 will install Hi Sam, I uninstalled everything related it SQL Server, including the Native Client. The only thing I didn't unistall is the books, because I could not uninstall them once SQL Server had been uninstalled. Allen Hi Sam, Here is the LOG information you asked for. MSI (s) (B0:04) [22:58:52:948]: Executing op: UpgradeCodePublish(UpgradeCode={ ...Show All

• Les R SQL Server Event Alerts on 2005

  We recently upgraded from 2000 SP4 to 2005 SP1. All of our alerts carried forward and we set up database mail which works fine. We have 2 event alerts that search for a certain text that we cannot get to fire. I can create a test alert and set it on a performace condition and it will fire off the emails fine. As soon as we change it to a event alert and type in text that we verified is in the event viewer application log we cannot get it to fire. We forward all events and created a custom job that will write to the event log and then forward it to our management server were this alert should be picking up these events becasue of the text search but it is not. I even changed the text to system generated text that is in the log already and i ...Show All

• Alexander Marinov Fail to call child package

  Have a parent package that calls many child packages (over 30) for a daily data warehouse update. On any given day, it randomly fails to call a child package with the following error: Error 0x800706BE while preparing to load the package. The remote procedure call failed. Its not failing the same package each day. I need a better explanation of this error message. Environment: SQL2005 Enterprise Dec2005 RTM on Itanium64 with Windows DataCenter. Yes, all Exec Package tasks are set up the same. All packages are stored in MSDB on our DataWarehouse server. Because we have such a large volume of packages (200), we are using folders to separate the packages. The parent package calls children in the D ...Show All

• createdbyx Slow connection. ASP page querying a linked server on MSSQL 2005

  Creating a web application.  Running a simple query "SELECT username FROM vwCustomer" vwCustomer is a view built on top of an Access DB which is set up as a linked server.  Within SQL Server that view responds immediately.  But when I try to access it from an ASP page it takes over 20 seconds to respond. Used the following to create the linked server: EXEC sp_addlinkedserver 'DBName' , 'Jet 4.0' , 'Microsoft.Jet.OLEDB.4.0' , 'c:\databases\database.mdb' GO EXEC sp_addlinkedsrvlogin 'DBName' , FALSE , NULL, 'Admin' , '' GO The view is simply(this works fine in SQL Server): SELECT * FROM DBName.db.dbo.customer The ASP page: SELECT * FROM vwCustomer Can anyone give me ...Show All

• jchau "service unavailable" error message

  I recently changed the service account for the SSRS service, after which I restarted IIS & reporting services. Now, I get an error message that says "Service Unavailable" whenever i try to load up http://localhost/Reports Event viewer looks clean...what's wrong After lots of playing around, I recreated the AppDomains for SSRS and it seemed to fix the problem.. ...Show All

• Sarah Cameron let user run a job

  Is there a way to grant a user the privilege to run a certain job in SQL agent without giving the user administrator's role The user should be able to see the job in Enterprise manager and run it . thanks Feng To make user able to run a job, just make him an owner of this job. Please direct this question to the SQL Server Tools General forum, as this is a SQL Agent specific question. I'll eventually move this thread there... Thanks Laurentiu ...Show All

• yeos_lee File Metadata and the Foreach Loop Container

  Hello, I want to set up a Foreach loop container to loop through several flat files. I have a connection manager set up for individual flat files. The metadata for the files is all the same. They are fixed width files, and contain sixty five columns. I didn't see a place in the container properties to configure the metadata of the files. How can a Foreach Loop Container 'know' the metadata of the flat files that I want to loop through Thank you for your help! cdun2 Thank you for your input! I'll see if I can run with the resources you have provided here. cdun2 If you are going to iterate through a number of files, you need t use a ForEach loop container ...Show All

• a0-0b escape characters

  Hi, I need to insert this command into a table, but I can't because. insert XXX set column1 = isnull ( Title , '' ) + case when ( case when title is null then 1 else 0 end ) = 1 then '' else ' ' end + isnull ( Last_name , '' ) + case when ( case when First_name is null then 1 else 0 end ) = 1 then '' else ' ' end + isnull ( First_name , '' ) + case when ( case when Middle_initial is null then 1 else 0 end )= 1 then '' else ' ' + isnull ( Middle_initial , '' ) END I don't know how to use escape sequence, I need insert just once thanks hi i really dont understnd your problem. does thi ...Show All

• jongas Parameterized filters on publication???

  Does anyone know if you can use any other parameters in the row filters for merge replication besides the functions SUSER_NAME() and HOST_NAME() I would like to create a publication for a couple thousand mobile databases to replicate with one SQL Database but filter what data they get based on some parameters. Do I have to hard code WHERE statements into static filters and create a publication for every user (seems a little ridiculous) Is there a proper way to do this using the SUSER_NAME and give each user a different connection name that will filter data properly Thanks, Patrick Kafka sorry, i'm not following you. Can you give an example of what exactly you want to filter on and wha ...Show All

• Zapp Configuration file for Connection Info (how do i set password)

  Hi All, I'm new to SSIS. I'm trying to build a simple package, run it on dev and migrate it to our stg and tst environments. It works on my dev environment great! It simply loads data from a flat file into a table. The trouble i'm having is exporting the connection string info to an xml file and runnign it on other environments. I am not storing the package on the db. I am saving to a file and running through SQL Server BI Development Studio. I go to "Configuration File" and export InitialCatalog, ServerName, User, Password to the file. I can manually change the xml to the new environment but don't know how to set the password. It's not in the xml and i am constantly getting "Login failed for 'sa'" errors. Anyone know h ...Show All