SQL Server

Page 4224




  • Topics
    Replies
    Last post
  • 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