Answer Questions

• Aaron Moore after set new_broker, it works for half hour and don;t work anymore, please advise, thanks!

  I use ASP.NET 2.0 and SQL 2005, the SQLCacheDependency didn't work stable for me, it usually works and after a while, it stops working. Recently, It doesn't work. Today I reset service broker by Alter DB set new_broker It seems all work, but too early to be happy, it doesn't work now anymore. I don't see any record in sys.transmission_queue And I don't see new entries in sys.dm_qn_subscriptions neither when I modify a record which bind to SQLCacheDependy. I see some errors in log like Message The query notification dialog on conversation handle '{8F8CC642-6340-DB11-8F09-0014227B7B80}.' closed due to the following error: '< xml version="1.0" ><Error xmlns=" http://schemas.microsoft.com/SQ ...Show All

• Thian Service Broker Queue Reader Question

  I'm creating an app that could potentially send thousands of messages to a Service Broker queue in a matter of seconds. The stored proc that reads records off the queue will call a remote stored procedure for each message to save data in a remote database. My question is this. How does Service Broker determine how quickly to read those messages off the queue it was sent to Ideally I'd like Service Broker to do most of its work when SQL Server isn't busy doing other things instead of contending with SQL Server while it's doing perhaps more important work. Is there any way to control this How does this work Thanks very much - Amos Rushi, Sorry I took so long to respond. I hadn't noticed you respon ...Show All

• thukralz We have a new white paper on Connectivity!

  Dear Forum Members, We've been working on a white paper targeting SSIS connectivity which we hope will help answer some of the key questions in the following areas : What are the SSIS components and their support level for ADO.NET, ODBC, and OleDB How to deal with 64-bit connectors what is supported, what is not Special sections on popular data sources such as SAP, Oracle, DB2, Flat File, XML. A comprehensive list of data sources and available connectors from Microsoft and other 3rd parties. You'll also find answers to why some of the things are the way they are today. Note that this white paper is currently under official editing and publishing in Microsoft. It'll be a while before it goes public off ...Show All

• SanderS XML Datatype Usage & Performance

  I'm interested in hearing any feedback on the following idea for utilizing the XML datatype in SQL 2005. I am building a customer profiling engine for use by multiple clients. The database is shared. Clients do not have their own seperate databases or schema's. The purpose of the system is to store, record, and transmit customer profile information. Such information would likely include attributes such as: name, email, phone, various demographic attributes. The system has to accomodate different profile attribute requirements across different clients. For example, a valid profile for one client may be nothing more than a unique id and an address while another client may not care about adress at all but does require a phone number. The tota ...Show All

• publicENEMY Cannot see the SQL Express Instance on the Network Server list...

  I have installed SQL Server Express and I can connect with it locally using "localcomputername\SQLEXPRESS". It is configured for remote connection and for some reason, when I browse for this instance on the Network Server, it does not appear in the list. I have unistalled/installed it several times and still I cannot see this instance on the SQL Network server list. Can anyone help troble shoot this frustrating issue... Thanks! SAM hi Sam, is the SQL Browser service up and running regards ...Show All

• Justin1021 Help with SQL

  Hi, i hope i posted int he appropiated forum. I hope you can help me with an sql sentence i dont know how to do,... The problem is that i have a database with fields like this: name, adress, etc.... , phone number but sometimes, i get them like this: paul, ... street... , etc... , 776509332 paul, ... street... , etc... , 234536445 paul, ... street... , etc... , 567847345 The client si the same, but he has more than one phone number.... I need to do, somehow, another table that makes this kind of duplicates to dissapear, and joins the phone numbers in an unique field for that person, so it will in the end look like this: paul, ... street... , etc... , 776509332 234536445 567847345 Can anybody help me Thanks ...Show All

• yababer NULL funkiness!?

  Iterating a WHILE loop, the following statement is executed repeatedly:   SELECT @groupContractId = contract_id FROM Import.dbo.GSGPAncP g WHERE g.group = @emp_group_code AND g.sub= @emp_subgroup AND g.plan= @emp_plan   If the statement returns NULL, @groupContractId ought to be set to NULL, correct SQL Server is (unfortunately) running in 65 compat mode, if it matters ... Instead, what I'm seeing, unexpectedly, is that variable retaining its value from the last iteration when the statement returns NULL. Have I gone crazy Is my brain cramping Should I lay off the coffee Should I drink MORE coffee I am aware of ANSI null in 7+ ... but I thought that was a ...Show All

• one2escape Error when file is saved to PDF

  I am calling a procedure that will save a file to PDF. It runs successfully. When I go to look at the PDF, I get a message, "Acrobat reader could not open 'Doc.pdf' because it is either not a support file or because the file has been damaged." This is how I'm calling the procedure: SaveFile(Dts.Variables( "varSSRS_URL" ).Value.ToString() + " /TestReports/MyReport&rs:Command=Render&rs:Format=PDF" , "C:\" + "MyReport.pdf" ) Ifaber, Is this a SSIS ralated issue If so, please provide more details about the error, which task, etc... I'm with Rafael. I cannot find a SaveFile function when searching in an SSIS script component. ...Show All

• Pockey Database Mail SQL 2005

  I'm having a problem with database mail in SQL Server 2005. I have set up a default profile. My SMTP server is not a localhost instead i've fed SMTP ip address and port no. The same setting in Outlook express works fine for Incoming and outgoing mails. but in SQL 2005 i'm not able to send test emails. The following errors show up in the sql server agent log Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-06-13T10:47:27). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine). ) Please help me out.... GUYS!!!!!! It WORK!!! See: Database ...Show All

• Praveen Dayanithi Is ProcessAdd done within a transaction mode?

  Is ProcessAdd done within a transaction mode This question is very basic. When you do a ProcessAdd, is it within a transaciton mode I mean, if the ProcessAdd fault and stop when it meets a mistake, the records before the midstake will still be in the cube or not. Thanks. Thank you, Mosha. You're right. I know how to do a begin transaction Task and a Commit Task in SSIS Excute SQL Task. Could you tell me how to do a begin AS transaction Task and a AS commit Task You mentioned to use AMO to make a self-difined controller. Please tell me more about this or give me some articals about this. I have no idea about that. Thanks a lot! ...Show All

• BonnieB Plug-in algorithm in data mining using sql server 2005-- modification for association , classification??

  managed plug-in framework that's available for download here: http://www.microsoft.com/downloads/details.aspx familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en#DMAPI . This package includes the source code for a sample plug-in algorithm written in C#. in this source code all .cs files are modified for clustering algorithm if my plugin algorithm is of association or classification type then what modifications are requried in source code why there is a requriment of making changes in source code i want all in dll like algorithm should be provided in dll application will configure itself and add new algorithm hence i want to generalize all You only need to create the source code for your ...Show All

• BLueDeViL Where to put DISTINCT in a CTE?

  CTE's are surprisingly useful for paging data, but I'm running into a problem where I have to add a distinct clause. The idea is to pull topic records for a user's forum posts, but only one topic record even if there are multiple posts in the topic. Here's what I have so far: CREATE PROCEDURE pf_PagedTopicsByUser( @StartRow int, @PageSize int, @UserID int ) AS DECLARE @Counter int SET @Counter = (@StartRow + @PageSize - 1) SET ROWCOUNT @Counter; WITH Entries AS ( SELECT ROW_NUMBER() OVER (ORDER BY IsPinned DESC, LastPostTime DESC) AS Row, pf_Topic.TopicID, pf_Topic.ForumID, pf_Topic.Title, pf_Topic.ReplyCount, pf_Topic.ViewCount, pf_Topic.StartedByUserID, pf_Topic.StartedByName, pf_Topic.LastPostUserID, pf_Topic.LastPostName, ...Show All

• Zapp problem creating varbinary(max) data type

  I'm unable to create a field with the type varbinary(max). When I try doing this with Management Studio, it tells me that the maximum length is 8000 bytes. I've also tried creating the field with DDL as shown below, but that doesn't work either. If I create the varbinary field with a length of 8000 or less, it works fine. Is there some trick to using varbinary(max) Thank you. create table images (filename nvarchar(250) primary key,photo varbinary(max)) Sounds like compatibility level is set to 80(2000) instead of 90 (2005). You can get the level by right clicking on your database and going to properties\options page. You can use the system procedure sp_dbcmptlevel to adjust your database. See BOL her ...Show All

• Rahul Garg Can't Send mail using MultiServer Admin

  Hi, I have a Master server which I want to use to handle jobs for our Production Servers. the master server has Outlook installed but the Target servers do not. I need to find a way to get the job to send a mail confirming whether the job has succeeded or failed but without having a mail client installed on any of the target servers. Currently the actual backups do run but the send mail section fails with the following error. xp_sendmail: Procedure expects parameter @user, which was not supplied. [SQLSTATE 42000] (Error 17985). The step failed. I can't see any parameter @User on BOL, it may be that using sendmail is not the best way foward here Any ideas anyone Try using http://www.sqldev.net ...Show All

• Tristany To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)

  What could be wrong I get this error when a stored procedure is executing sp_OAMethod from SQL Server 2000 SP4. EXEC @rc = master..sp_OAMethod @Obj, 'Execute' The linked server is SQL Server 2005 x64. Already installed is SQLServer2005_BC_x64.msi version April 15, 2006. Local server is SQL Server 2000 SP4. I can execute the sproc successfully in Query Analyzer from my local dev box which has both 2000 and 2005 installed. Profiler in 2005 indicates success for the whole sproc. It fails when I execute in Query Analyzer while connected on SQL 2000 SP4. Tried this with 3 different machines SQL Server 2000 SP4. The server do not have any 2005 component installed. According to Profiler in 2005, the last event that happen is ...Show All