-
- Protect from SQL Injection?
by Stephen_Sbh
- 5 Replies
- Last post
by Raul Garcia - MS
- Hi,
Just read about SQL injection, and tested it out with sample database, and it does hack my database, the article show to prevent SQL injection by using application code to remove those keywords and change single quote to double quote, is there any method to prevent SQL injection directly using the database system itself, maybe stored procedure or anything
Thanks.
-
- Deployment Of SSIS With Config Files
by Karunakaran
- 14 Replies
- Last post
by perjorgen
- I went through other threads and links on this subject. Still one thing which concerns me is the config files. My current folder path is C:\Karunakaran\folder1\folder2\ Under folder2 I have the following files 4 dtsx files 1 .database file 1 .dtproj file 1 .dtproj.user file 1 .sln file 1 .suo file Config folder ( C:\Karunakaran\folder1\folder2\Config\) common.dtsConfig oracle.dtsConfig Based on so
-
- Possible to stop SSRS GUI from destroying hand rolled mdx in datasets by silently reverting to design mode?
by JoGo
- 3 Replies
- Last post
by JoGo
- Since as soon as you extend your mdx datasets manually you can no longer switch back into design mode without losing your changes, right
If that's the case, is there some way to disable design mode completely i'm finding that the GUI has the tendency to SILENTLY revert the dataset editor back to design mode while I'm busy editing a layout, thereby losing my carefully crafted MDX.
-
- why any function related to prior period in my data does not work?
by Helen999888
- 10 Replies
- Last post
by Helen999888
- Hi, all,
I am encountering a very strange problem that I cant get any value for prior period for my KPI. E.g, I am defining a KPI goal which will be the value of the prior period multiplies 1.2, but then no result returned for this definition, only result returned for value of current period, if I defined the goal as anything of current period Why is that
I am very much looking forward for
-
- new to SQL - create table command question
by simongw
- 2 Replies
- Last post
by Jens K. Suessmeyer
- hi
can someone please explain the following please
why does this fail with specified owner testdb does not exist or you do not have permissions
create testdb.testtable (
testval int
)
yet if i create testdb and then run the following against this new db
create testtable (
testval int
)
command command completes successfully......what am i n
-
- SP_Change_Users_Login
by Pereira
- 7 Replies
- Last post
by Raul Garcia - MS
- I am moving several databases that belongs to a single application from MSSQL2000 to MSSQL2005. After sucessfully moved and converted the databases I need to fix the users login and I am using sp_change_users_login procedure to do so. My questions are: I have an application user that needs to be fixed in several databases - how can I fixed the login all once Also is there a way to turned the che
-
- Trying to figure out number of pages in report
by dribar438960
- 2 Replies
- Last post
by Hi Its Me
- Greetings,
I have a report that is created that is typically 2-3 pages long. I've tried the "ExecutionInfo.NumPages" but it always results in "1" as the answer. Code is something like this:
============
...
Dim reportHistoryParameters As sqlprod1_res.ParameterValue() = Nothing
Dim SessionId As String
Dim execInfo As New ExecutionInfo
-
- Login scripting to a file
by KrisG
- 3 Replies
- Last post
by Naras
- I am new to DMO and I am trying to find a way where I can create a script file containing all server logins. THis needs to run on a daily basis.
Anyone have any examples to share
-
- truncation error message
by CSharpCoder
- 14 Replies
- Last post
by Phil Brammer
- Ok, this is starting to drive me nuts, I've been trying to get this to work for 2 days now. I have a .csv file that I'm reading and importing the data into my table. I defined Derived columns for the type and the lengths as well. I have one column that keeps kicking out this error: The column in the db has a length of 50, the column in my derived column is set to 50, now there are some strings in
-
- SQL Parameter and wildcards, how to make it work?
by J_bob_1
- 1 Replies
- Last post
by J_bob_1
- Hello, I have what should be a very simple problem, but I cant solve it.
I want to have a stored procedure return a table query (no problems here) but I also need to supply several parameters to the stored procedure (again, no problem!)
Here is the problem, I need to be able to supply a wildcard into the stored procedure as an argument somehow. I can do this already, but the results are
-
- SSIS Logs
by PedroCGD
- 7 Replies
- Last post
by jwelch
- Following the blog of jamie, I was trying to aply it to my project... but my requirments are a little different than him...
http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx CommentPosted=true#commentmessage
I have inside the ControlFlow several sequence containers and inside each container I have several dataflows. I want to g
-
- Received message constantly processed.
by marina B.
- 7 Replies
- Last post
by marina B.
- Hello,
when is seemd that everything works some weird behaviours comes out.
I try to summarize the problem without to post the complete code.
Service Broker is set to have a dialog between two databases on the same SQL Server instance.
The Initiator queue has retention=on and there is an activation SP to handle errors and Target's end dialog message. The Target queue has retention=
-
- How to Send a SQL Server notification to Messenger
by julianenrique
- 3 Replies
- Last post
by Joe Webb
- Hello,
I'm trying to send a SQL Server notification to MSNMessenger and also to Yahoo Messenger, but I didn't find the way. If you have some information about it, please answer this question as soon as possible.
Thank you so much
-
- Error with SMO.TransferData() (Exception from HRESULT: 0xC0011008)
by ALight
- 11 Replies
- Last post
by ALight
- OK, I have tried just about everything over the past 9 hours. I think I've read through every forum regarding anything similar to errors with SMO and TransferData().
However, I still can't fix my problem.
What I'm trying to accomplish is a workaround for deploying my database application using ClickOnce. Since I can't include the database when upgrading (which would wipe out users' d
-
- Report Builder
by raviparthan
- 1 Replies
- Last post
by carsc
- Is Report Builder capable of building any complex reports that Visual Studio Report Designer can build
What are the limitations of using Report Builder with SQL Server Databases
-
- 64-Bit SQL Server 2005 (Enterprise), SQL Agent Notifications and Database Mail
by Cordell Swannack
- 3 Replies
- Last post
by Ernie Fosse
- We have database mail configured on our 64-Bit SQL Server Enterprise 2005 (SP1) and are able to send test messages from the context menu that appears when selecting database mail component.
However for some reason when a SQL Agent Job fails, no emails are sent to the 'operator' that has been defined for the job. I have confirmed that we have the operators correctly configured. We also have a sm
-
- importing from excel into SQL Server 2005 changing values to NULL
by Philip Jaques
- 7 Replies
- Last post
by Jay Vora
- I can't figure this one out...
I have an Excel spreadsheet (Excel 2003 format) with a column of values. The column is formated to General (although I've tried it formated to text). The values are alphanumeric. However, there are a few values that are completely numeric.
Example:
_ITEMNUMBER_
1-528
K214-5
184PR
45678
As can be seen, the last value is completely numeric. I am
-
- Could not load package because of error 0xC001000A
by Fahad349
- 5 Replies
- Last post
by EDUARDO_SENGER
- I am trying to run an SSIS Package by using DTRun.exe this way C:\Documents and Settings\Fahad>dtexec /SQL DataDownload /Conn "Data Source =TriMurti;User ID=sa;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate =False;Password=gamba" /U sa /P gamba And the outcome of the command was Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C
-
- Disabling extended stored procedures for security
by fpbear
- 4 Replies
- Last post
by Arnie Rowland
- Our security team wants us to disable access to (or drop) all of the built-in extended stored procedures in MSDE 2000 as they feel it is a vulnerability. Where can I find out which extended procs are safe to disable or how we can disable them during install time Or, is the security team being too cautious and we should just tell them to leave these intact
-
- The SSIS package does not run using SQL Server Agent job
by john zhang
- 10 Replies
- Last post
by IgorB
- Dear All,
My SSIS package is "Extract" data from Oracle and Load into SQL Server.
The SSIS package does not run when I call the SSIS package from a SQL Server Agent job step
I have gone through all the steps in the doc http://support.microsoft.com/kb/918760 , but it still doesn't work.
Is it because of connection to "Oracle" database and SQL Server Agent ser
-
- smalldatettime
by arkiboys
- 7 Replies
- Last post
by hunchback
- declare @ValueDate smalldatetime set @ValueDate = '21/05/2007' select @ValueDate
error: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
Please note, if '05/21/2007' is used then there is no error. How is it possible to get 'dd/mm/yyyy' as above to work please Thanks
-
- missing borders when SSRS report is rendered in Sharepoint
by Suman553787
- 0 Replies
- Last post
by Suman553787
- Hi ,
I am trying to host an SSRS report as a web part in Microsoft Sharepoint 2007. All the elements and data come out well except that a few borders are missing in the rendered report.
What could be the possible cause and solution for this.
Please suggest.
-
- Reporting services permission denied on microsoft access linked
by sharrock
- 0 Replies
- Last post
by sharrock
- I have a Microsoft access 2003 database with tables linked to a number of "SharePoint lists"
I do this by going to File -> Get External Data -> Link Tables. A new window pop-ups in which I select Files of Type to be Windows SharePoint Services.. Then I select the correct site.. Then select the correct Lists.. Then access correctly links the tables to the SharePoint lists.
-
- IDENTITY_INSERT Issue
by Jim Work
- 3 Replies
- Last post
by Jim Work
- INSERT INTO dbo.my_table (table_key) VALUES (007) -- Msg 544, Level 16, State 1, Line 1 -- Cannot insert explicit value for identity column in table 'my_table' when IDENTITY_INSERT is set to OFF. SET IDENTITY_INSERT dbo.my_table ON INSERT INTO dbo.my_table(table_key) VALUES (007) SET IDENTITY_INSERT dbo.my_table OFF -- Msg 1088, Level 16, State 11, Line 2 -- Cannot find the object &qu
-
- SQLIS Checksum Install Problems
by zbethem
- 2 Replies
- Last post
by DarrenSQLIS
- For detecting delta records, I'm a big fan of SQLIS' checksum transform. I'm having difficulty in it's install on my current machine, however. After the installation and the new transform is added to my DataFlow toolbox... I can't open the UI for the transform to define the checksum. Instead, I get the following error: =================================== Could not load file or assembly 'Microsoft