Answer Questions

• dreameR.78 Stored procedure activated more than once

  Hi guys! Is it possible for a stored procedure to be activated more than once even if a message is sent only once After sending the message, I check the sys.dm_broker_activated_tasks and see that it activates more than once. Is there a way for me to prevent this from happening Thanks a lot! :) If you never want more than one activated task you can set the max_queue_readers property to 1: ALTER QUEUE your_queue WITH ACTIVATION (max_queue_readers = 1); This will happen and it caught me out. The broker internals will probably activate more than one procedure to make sure that all messages are being processed, a bit like a mop up. The argument for this I h ...Show All

• Pwint Is anyone using ActiveCipher by RedCraft Software?

  I am considering this third party encryption tool for use on SQL Server 2000 and would like to hear from someone who is using it in a production environment. Thank You There is none that I can find. I'm just looking for another SQL Server Professionals opinion on the software. Could you recommend another Microsoft Forum that might be more appropriate You could try the Community Chat forum - Hot Technology . It appears to be meant for discussing various technologies. I am not sure what other forums you could use. I can only tell you that we cannot make recommendations of third party products for legal reasons. Thanks Laurentiu This forum addresses ...Show All

• trumpy81 Problem connecting remotely using osql

  Hi, I am using osql to connect to my remote MSSQL server. I am able to get a prompt for password and telnet to 1433 just fine, so I conclude this is not related to firewall. When I try to connect I get: C:\Program Files\Microsoft SQL Server\80\Tools\Binn>osql -S xx.xx.xx.xx -U test Password: [DBNETLIB]SQL Server does not exist or access denied. [DBNETLIB]ConnectionOpen (Connect()). When I try to connect from 'localhost': C:\Program Files\Microsoft SQL Server\80\Tools\binn>osql -U test Password: 1> -- This is Microsoft SQL Server 2005 - 9.00.1399.06 and both local and remote connections are allowed. Logs don't show up anything. Thank you. osql -Sservername -Uusername -Ppas ...Show All

• fscarpa58 creating and scheduling job for SSIS

  Hi All I want to create and schedule job for my SSIS packages. But I have no idea how to do that. Paarul wrote: Hi All I want to create and schedule job for my SSIS packages. But I have no idea how to do that. Search for SQL Server Agent and SSIS. I am working on this for the first time.Would you please tell me the steps involved in moving the packages from BIDS to server Shall I copy all the packages in MSBD and than create jobs for eah one of them What should Property Path and Value contain Do we have to provide the Property Path and Value for the packages And what is advantage of using Data Source over Connection MAnager ...Show All

• BJHop Can someone Help me?

  Hi peoples Im newbie in Sql server 2005 and learning  Here is my problem: I have: Table1------ Complaint_Types------- TypeID       int PK Type          VarChar Table2 ----Members---------- MemberID       Int Pk MemberName  VarChar Roomnumber  VarChar Table3 ----Computers---------- ComputerID             Int Pk ComputerDescription VarChar MemberID                Int Fk Table4 ----Techs---------- TechID     &nb ...Show All

• StGeorge Logging in SSIS

  Logging in SSIS as compared to DTS is more complex to set up with so many events. What events should I choose if I need something similar to DTS package logging i.e. I simply want to see which tasks executed at what time and whether they failed or succeded and if they failed, what was the error I'm currently logging ALL builtin events. I'm only keeping the last 5 days worth of event records. I have a log cleainging job that run every night deleting old records. It's only about 120,000 records and minimal disk space. I have plenty of disk space so I might as well use a little of it! Someday as I add more SSIS packages I will need to go with a scheme like the one Jamie suggested. Note: I keep my custom ev ...Show All

• tommazzo Problems with styles in reporting services 2005 - help

  Hi all,I have some reports built using vs.net 2005. On the reports i am changing lots of styling definitions such as the backround image of the report and the gradient style of the charts etc....... when i am deploying the reports into the reports manager lots of the style and changes i havr made does not apear on the web. I have installed sql server 2005 sp1. Any ideas Cool, would be nice if you could post that back to the group, that will help a lot people having the same problem. jens. But you aren’t using external images etc. Which are evenentually not reachable form the report server What changes did you make HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Maartin Using Push in RDA for sync the data from sql mobile to sql server 2005

  Hi Everyone, I have tried the Sync the data from sql server mobile (.SDF) to Sql server 2005 (.mdf).In push command, i am getting the error "Sql Server Everywhere encountered problems when opening the database". string rdaOleDbConnectString = @"Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=master;Data Source=PRASSANA\PRASANNA;Password=master"; qlCeRemoteDataAccess rda = null; try { rda = new SqlCeRemoteDataAccess(); rda.LocalConnectionString = "Data Source=D:/DATABASE/test.sdf"; rda.InternetUrl = http://localhost/Dataset/sqlcesa30.dll ; rda.Push("company", rdaOleDbConnectString, RdaBatchOption.BatchingOn); MessageBox.Show("Completed"); } cat ...Show All

• R Raghu How to assign OR get Time value to a colum

  How can i store time value in a column. And also i need to compare the values. Another problem is , how can i get the Current time of the server.(something like getdate() ) Happy Coding hi, there's no other function aside form getdate(). if you want it to be stored automatically to a column you have to enforce a "default constraint" thanks, joey MasterG wrote: How can i store time value in a column. And also i need to compare the values. Another problem is , how can i get the Current time of the server.(something like getdate() ) Happy Coding Hi, Please see answer; http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1000324&SiteID= ...Show All

• Tianyu Li ODBC-Call Failed - Access

  We have this fairly simple Access database with a link table to a view in an SQL Server. The Select Query in Access is a simple select from this view with a view criteria set. Nothing fancy. What is driving is moderately crazy is that this Select Query in Access seems to work fine for months and than all of a sudden (same query performed around the same time with about the same workload on the SQL-Server) it responses with the helpful "ODBC-Call Failed" message. Closing the Access database, taking a coffee, coming back againg and try the exact same Select Query normally works, no "ODBC-Call Failed" message. It not happens always, mosty we're fine. When it happens it happens for all subsequent queries tried. W ...Show All

• Harry_Leboeuf Migrating Access XP database to SQL Server 2005 Express

  I want to migrate my Access XP database to SQL Server 2005 Express Edition. The Start Menu does not display any migration assistant in SQL Server 2005 Express menu list. How to migrate it hi, never tried it my self, but have a look at http://www.microsoft.com/downloads/details.aspx familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en regards Access includes a tool called the upsizing wizard that will assist in moving your database to SQL. Regards, Mike ...Show All

• luai7 Connect to SQL Server from ASP.Net application

  Hi I developped an ASP.Net application (with Web Dev Express ) wich attempt to connect to SQL Server Express (installed in the local machine) using Windows authentication.When i launch my application within Web Dev or from IE navigator i receive the following error message : Cannot open the database 'MyDB' login failed for user ServerName\ASPNet.I use SQL Server Management Studio Express to give the user ServerName\AspNet permission to connet to the database but i still receive the same error message.I created a user with strong password within Management Studio with connect permission and attempt to connect from my application using SQL Server authentication i receive the error message : The user 'UserName' is not associated with a tr ...Show All

• samame Creating a dynamic excel file

  Is it possible that i can create a dynamic excel file (destination) ex, i want to create a Dyanamic Excel destination file with a filename base on the date this will run on jobs. Is this possible 11172006.xls, 11182006.xls Hi Thanks anyway I'm gonna test it, if it's going to work, I hope it does. I'll reply again after i check it out Anyway thanks, hope this work Jaegd, Not sure if that will work. I am working on a similar problem now. I am trying to load the contents of a table into an Excel file every week with a datestamp in the filename. I've tried a few approaches but haven't found a good solution yet. But here's what I found so far. 1. ...Show All

• schmod54 Report Properties Window

  "InteractiveHeight is only supported on RS 2005. Opening a report in BI Development Studio of SQL Server 2005 will automatically add this property. You can find the property on the Report element. In report designer (properties window) it is also on the report element / Layout / Interactive Size / Height." Why don't I see the Report Properties screen that includes the Interactive Size elements My Report Properties screen looks the same as it did in VS2003. I need to modify the InteractiveHeight element. It has been added to the RDL source. Here's what's installed: Microsoft Visual Studio 2005 Version 8.0.50727.762 (SP.050727-7600) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Professional Mic ...Show All

• ssfftt Whats the difference between a dialog and a conversation?

  As above BEGIN DIALOG refers to a dialog conversation and hence the documentation will use the words 'dialog' and 'dialog_handle'. END CONVERSATION refers to any conversation* and hence the words 'conversation' and 'conversation_handle'. If you find places where one term is used instead of the other you could file a documentation bug and we will fix that as soon as possible. Rushi *: Although we only have one type of conversation today, in the future we may have other types of conversations that reuse existing language/syntax (such as the END CONVERSATION statement) and at then it should not be necessary to edit the documentation on those statements. I guessed as much. BOL however uses th ...Show All