Answer Questions

• Jamie Thomson SQL Service Broker - Transport security

  If all my SQL Server instances are mutually trusted, am planning to implement transport layer security with Windows authentication. My query is that if I'm using Windows authentication do I need certificates to be created Though I am using Transport security, I can achieve encryption by ENCRYPTION - ON in the Begin Dialogue conversation. I assume Message integrity using MD5 signatures are by default provided by Service broker irrespective of whichever service options we choose Can I have some article references on how these security mechanisms will impact the performace of Service broker communications Thanks a lot, This one talks on similar topic http://forums.microsoft.com/MSDN/ShowPo ...Show All

• GeeMann Cannot bulk load because the file could not be opened. Operating system error code 5(Access is denied.).

  I am facing a issue with bulk upload on Test Server. Issue: When running Openrowset command from SQL server other that Test Server query runs fine when trying to run the same command from Test Server it gives error. Msg 4861, Level 16, State 1, Line 1 Cannot bulk load because the file " \\ServerName\input\FileName.csv " could not be opened. Operating system error code 5(Access is denied.). For example: If the command is run from System A connecting to SQL Server instance on Test Server Test Server it gives this error. If the same command with same rights is run from any other SQL server instance say Dev1 its running fine. If the command is run from Test Server connecting to any SQL Server instance includin ...Show All

• fchapa How to get records (In this week) only?

  Hi, How to get records from MSSQL database which only recorded from the biging of this week in example my week begin from Sunday.. Only for one table, and yes the table have timestamp column.   I'm also trying to use this query to get the number of records inserted on this month: SELECT COUNT(*) FROM MyTable WHERE DateTimeColumn > MONTH(1)   It doesnt return the correct value for records inserted on Feb!!   You might want to be more specific. Is this for a single table or for all tables Does/do your table/s have timestamp columns Weeknumbers are probably the trickiest part of a date. While this works well for US- ...Show All

• Robert3234 Package Runs in 1 minutes in Visual Studio but takes 5+ (sometimes hanges) as Job

  I have an SSIS package that when run from Visual Studio takes 1 minute or less to complete. When I schedule this package to run as a SQL Server job it takes 5+ and sometimes hangs complaining about buffers. The server is a 4 way 3ghz Xeon (dual core) with 8GB ram and this was the only package running. When I look in the log I see that the package is running and processing data, although very very very very very slowly. Has anyone else experienced this Thanks for your help Marcus Please share your connection strings... Could it be that the user running the job (the user assigned to the SQL Server service account) doesn't have access to the remote server/database You need to identify ...Show All

• ACCOUNTINGONLINE.US SQL Reporting Layout Expression question.

  I need to add a "%" symbol after an expression in the sql reporting services layout. How would I do that example: =Fields!Number.Value <~~~ How do I add the percentage symbol Sinh, Try = Fields!Number.value & "%" or you can go to the textbox properties, select format tab, Format code, click on ..., then choose percentage as the format type. Ham Moved thread to Reporting Services group. ...Show All

• jeffg90 Script Task, debugger stops and waits indefinitely

  Hello, I have MS SQL Server 2005 with SP1 installed, version 9.0.2047 I am trying to debug a Script Task in SSIS. I have break point on the first line of the code. SSIS runs and eventually launches MS Visual Studio for Applications. Line with the break point is highlighted in yellow. After that Visual Studio is frozen. F5, F11 or any other key press produces a popup which says the following: Delay notification. Microsoft Visual Studio for Applications is waiting for an operation to complete. If you regularly encounter this delay during normal usage please report this problem to Microsoft. Please include a description of the work you were doing in Microsoft Visual Studio for Applications and when possib ...Show All

• newyuppie Can't copy the .mdf file in an app because it's being used by another process

  Hi guys, I'm trying to copy database files along with a c# app to a backup store, & I get the error in the subject line even when I've detached it from sql server. Now, even in the application, if I try to detach it or delete it, it gives the same error. I'm really new at this, so any help would be greatly appreciated! Kimmy Detaching it still gives you the error PsFile can help locate the open file and close it. http://www.sysinternals.com/Utilities/PsFile.html I used PSFile & it says it's not being used. But I still can't copy it to a server. It says it's being used by another person or file...how do I find out what that is Thanks! Kimmy w ...Show All

• IvanOrdonez How to get all stored procedures script like DDL for table?

  With SQL Server Enterprise Manager, you can get all objects DDL script with drop option in one text file, but not for stored Procedures. How to generate all SP script without using third party tools In the Object Explorer window, Right-click on the database, click on [All Tasks], then click on [Generate SQL Scripts...]. In the window that opens, click the [Show All] button, and then the [Stored Procedures] checkbox. ...Show All

• cjou2004 rsAccessDenied when using ReportViewer

  Hi all, background: I'm using reportviewer <-- report on localhost/server <-- deloployed from RS 2005 <-- report created agains Dataset reportFromCube<-- crated against datacube EmployeeCube <-- EmployeeCube was created in AS 2005 against EmployeeDW (simply, I'm using a reportviewer to browse the report that was deployed on http://localhost/reportserver ) I can browse it correctly in a simple web form application that only inludes the reportviewer. But if I add the reportviewer in my project , I can't browse the report and get "rsAccessDenied" error says The permissions granted to user 'MMH\ASPNET' are insufficient for performing this operation. (rsAccessDenied ) I searched through out this ...Show All

• Sean Aitken ADO Connection issue

  Hello All, I have made a small application on my system in delphi v7 that uses the ado connetion components and works fine on the remote sql server db. But my client gets a "cannot find server" on his system with the sql server/db local. My connection string this... Provider=SQLOLEDB;Password=password;Persist Security Info=True;User ID=USER;Initial Catalog=MyDB;Data Source=SERVER01; his connect is... Provider=SQLOLEDB;Password=password;Persist Security Info=True;User ID=USER;Initial Catalog=MyDB;Data Source=HISSERVER01\APP; I have changed the Data Source to (local) and local, as seen in another post but this had not effect. We have check his MDAC version verse mine and they are the same, save he has sp ...Show All

• Go4More Please guys i am confused between VS 2003 and RS 2005

  Is it possible to use SQL server reporting services 2005 with Visual Studio 2003 I mean when you say new project under VS 2003 does it show under project types: Business intelligence projects using Reporting services 2005. Since we have done lot of work using VS 2003(framework 1.1) and now really does not want to get into using Framework 2.0 (VS2005) But want to use just the reporting services 2005 with VS 2003. Thank you all very much for the valuable information. You can create RS 2000 reports with VS 2003 and deploy them to a 2005 Reporting server however you won't be able to use any of the new features of RS 2005. I would advise you to use the SQL Server Business Intelligenc ...Show All

• Tihomir Ignatov Please help: object reference not set to an instance of an object

  I have created a new local website from the "Personal Web Site Starter Kit" template. I got an error message when i double click on the database file: "Object reference not set to an instance of an object." I cannot open Personal.mdf in VS2005. I have not tuch anything. SQL Server 2005 Express is running in bacground. What is wrong This sounds like something is not registered correctly in Visual Studio. The ASP.net forums is a better place to ask questions about ASP.net and Visual Web Developer. You can find all the forums at http://forums.asp.net/ and the forum that is specifically about SQL Express in VWD at http://forums.asp.net/54/ShowForum.aspx . Mike ...Show All

• RavenWorks Detecting local Sql instances

  I would like to find out what instances of sql are installed on any given machine. For instance, if a machine has SQL Server 2005, SQL Express 2005 and MSDE 2000 installed. I would like to be able to know the versions of each, and ultimately choose the one which is the best for the user to use. For example, I would like to rank the instances, 1. SQL Server 2005 2. SQL server 2000, 3. Sql express, 4. MSDE So I would basically like to default to the best choice available locally for the user. Is there any way to do this using SMO Thanks... Hi Johnny, Yes, the versions will be the same, however the "Edition" property (from memory) will display the actual, well...edition. Have a browse of the d ...Show All

• Nicw Jobs lose ownership/permissions when server reboots

  This is sort of a DR issue since it involves reboots and power failures. We have MSSQL 2005 SP1 and unpatched systems, but in particular we have this problem still with the SP1 server (in addition to the unpatched systems). Running on Win 2k3. It seems that upon reboot, our stored SSIS jobs lose their pemissions and/or ownership for execution. It doesn't happen at every reboot or power failure, but seemingly more than half the time. Here is the error reported: The job failed. The owner () of job Job_1 does not have server access. But checking the properties of the job and it shows an valid owner in the Owner field. I believe we are using Active Directory for authentication and the user listed is valid in that respect. We have "fixed" thi ...Show All

• Scotty12105 execution package task-SOS

  hello to every body.. well i have a problem.. well i created a package the task of which is to update thedimensions and the fact tables from the tables of source. i created a configuration file with all the parameters that are nedded (connections managers; parameters of packages).this config file will include all the paremeters need for the execution of other packages In that package i call an other package (execution package task). this package normally will take the parameters of the parent package isn't it (i put the parameters of this package to the config file of the parent package). i must also note that for the second package called there is also a package... i must also note that i have 2 DWHs (a and b) for testing. ...Show All