Answer Questions
sri111 long running transaction blocking queue
Hello, I seem to be misunderstanding the way transactions work with service broker queues. We have developed and deployed a service broker application that 5 queues and a windows service for each queue on multiple servers (3 currently). Due to a last minute issue, we had to not use transactions when the services executed a recieve and I am not updating the code base to use transactions and am running into blocking issues. One of the services runs for 90 seconds (spooling to the printer) and all of the servers block on the receive operation for this queue. I thought that if I was receving messages from a single conversation, other receives against this queue would not block. Thanks, Jim Stallings ...Show All
lagu2653 how to display a field in a report as HTML file?
Hello.. I have a question about how to display this field. You see, from the database, the field has a value of <html><body> ... </body></html>, or something like. But when I try to display it in the report, it doesnt show as an HTML file, but as a text file.. Just want to ask if its possible to display a field in the report as an HTML file Regards, Bunny_Moon This is currently not possible. Rich text, such as Html, is a frequently requested feature and is something that may be planned for a future release. hmm...okay.. I've been trying to display it since yesterday.. to no avail.. :( Anyway, thanks.. :) ...Show All
Erick-Flores Download for redistributable SQL Server Express Edition?
Where do I find the setup files needed to redistribute sql server express installation files I downloaded the SQLEXPR_ADV.EXE but the files disappear as soon as you cancel the installation. I need the sql server setup files to package with my program fr distribution. THANKS SO MUCH Thanks for prompt reply. Yes, I know and that is exactly my question (Second, when you doubl-click the file SQLEXPR_ADV.EXE, it starts to extract all packed files into a temporary directory. You can see a progress window and it will tell you the temporay directory where you can find unpacked files and folders. Then it will start to perform setup. After setup finishes, this temporary directory will ...Show All
Stikstofman SCHEMABINDING and Partitioning
Hi all, I was wondering if someone could tell me why I am unable to switch data out of a partitioned base table when an indexed view is created on it... obviously SQL 2005 rules state the view schema bound to the base table so the base table cannot have any schema changes applied to it ie column name data types ect. But the odd thing here is that as far as I know a scheme boundary really isn’t a schema value depended option. In other words it doesn’t affect the schema result of the base table at all. It only affects the data segregations and potential location right so with that said. if you had created a base table and applied a partition scheme to it then later created an indexed view on that base(now partitioned) table (additionally t ...Show All
az81 Merge Replication downloading rows immediately after uploading SQL 2005
Hi I have noticed that four out of the 145 tables being replicated in my topology perform a mysterious update. If I insert data at the subscriber then synchronise the upload is completed followed by immediate downloading of the same identical set of rows as updates. Has anyone seen anything like this. I cannot see any difference in the filter joins or article settings compared to any other table in the system but these four consistently do this. Publisher/Distributor: SQL 2005 SP1 on Win 2003 Server Subscriber: SQL Express 2005 SP1 on Win XP SP2 Cheers Rab Rab, do you mean the newly inserted rows on the subscriber will be updated during the downloading phase Are you using any parition options I tr ...Show All
Vivienne.Zhou How to make a File Share Subscription running on Vista?
I recently migrate to Vista. I had a bunch of reports with file share subscriptions that were running fine on XP. After installing reporting services on vista (that part only was a challenge), I re-created my subscriptions using the report manager. As expected, when a subscription is executed, the ‘last run’ column shows the last time the report output has been delivered to the file share and the ‘status’ column shows ‘New Subscription’. I thought that this was the signature of a successfully configured subscription. But surprisingly, there is nothing in the file share. The directory is empty. Anybody has an idea why Anybody knows how I could possibly find information on my ...Show All
ivanchain Error during installation
I was installing SQL Server 2005 Standard Edition on Windows 2000 server. During the prerequisites installation .NET 2.0 installed sucessfully but unable to install Microsoft SQL Native Client and produce an error. Error occurred during installation: Error 1619 installing Microsoft SQL Native Client. See log file for more detailed information. This installation package could not be opened. Varify that the package exists and that you can access it, or contact the application vendor to valify that this is a valid Windows Installer package. Log File Errors: === Verbose logging started: 7/24/2006 16:04:11 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:\WINNT\system32\msiexec.exe === MSI (c) (04:98) [16:04:1 ...Show All
XNA Rockstar Select statement possiblities??
Hello all, I was wondering if there was anyway to use an "IF" statement inside an SQL SELECT statement. something like the following: SELECT somecolumn, SUM(something, something) AS Total, (IF Total <= 40 Then SUM(something, something) / 60 * somecolumn) AS Total2, SUM(0,0) AS GrandTotal Else SUM(something, something) / 60 * somecolumn) AS Total2, SUM((Total - 40) * somecolumn) AS GrandTotal End If) FROM someTable any idea how to accomplish something simular to this use the case statement with the sign function select 'SOMEVALUE IS ' + case sign(somevalue-40) when 1 then '' else 'NOT' end + ' GREATER THAN 40' as IsSomeValueGreaterThan40 from someta ...Show All
WinFormsUser13232 Querying multiple databases
Hello, This is probably a simple solution but I'm a bit confused about which flows to use. I have two databases on different servers that contain the same information but for the appropriate server. I want to retrieve data from each of the servers using a "select" statement. Would I use a ForLoop and change the connection in a Script Task and then execute the SQL statement Or can a ForEach Loop be used, but I'm not sure which type of enumerator. Thanks for any help you can give. Thanks for the help...I'll give it a try and see if I can make it work! I'm not sure I understand how to change the connection string. Could you elaborate a bit, please ...Show All
kvnfrazier how to dump database to MSDE
Hi In my app. i'm using sql server 2000 now I want to move to MSDE2000. I have two Queres. my application environment is Vb.net 1.how to dump my sqlserver database which i was already using to theMSDE and 2.can i connect this MSDE to MSSqlServer2000 Hi Andrea , Thank you verymuch. -GRK hi, GRK wrote: Hi In my app. i'm using sql server 2000 now I want to move to MSDE2000. I have two Queres. my application environment is Vb.net 1.how to dump my sqlserver database which i was already using to theMSDE and you can "move" the database from the SQL Server 2000 to the MSDE instance in 2 easy ways.. 1. you can backup (full backup) the database on the original ma ...Show All
Puntor Stopping job after timeframe
Is there a way to stop a scheduled job after a particular amount of time has passed I have jobs in which the running SSIS packages wait for a file to appear in a particular folder. As is, the job will wait all day. What I want is the job to fail if after say 5 hours, the file never appears. (Plus for the next day I need to package to "reset" itself with the current date.) That is exactly what you do. Yes, it is a hack. In most places that I work with that have larger numbers of servers, we don't use SQL Server Agent at all and instead purchase 3rd party software to handle all of our jobs. Of course, the 3rd party software handles scheduled tasks for DB2, Oracle, Windows, Unix, and several other ...Show All
F.Costa Loop Through Flat Files Based On A Date Range
Hello, I currently have a For Each File container that loops through all files from a specific directory. The files have a naming convention that looks like this; CDNSC.CDNSC.SC00015.01012007 The last segment of the file name is the date of the data in the file (mmddyyyy). The create date for these files is always a day later than indicated in the file name. What I would like to do is to have more control over the 'range' of files that are looped through by using the date portion of the file name to define what group of files should be looped through. Ideally, I would like to have a 'StartDate' variable and an 'EndDate' variable that I could define at run time for the package, and the package would loop through all of the files ...Show All
divya mittal Merge Replication downloading rows immediately after uploading SQL 2005
Hi I have noticed that four out of the 145 tables being replicated in my topology perform a mysterious update. If I insert data at the subscriber then synchronise the upload is completed followed by immediate downloading of the same identical set of rows as updates. Has anyone seen anything like this. I cannot see any difference in the filter joins or article settings compared to any other table in the system but these four consistently do this. Publisher/Distributor: SQL 2005 SP1 on Win 2003 Server Subscriber: SQL Express 2005 SP1 on Win XP SP2 Cheers Rab Rab, do you mean the newly inserted rows on the subscriber will be updated during the downloading phase Are you using any parition options Yes ...Show All
Bill Henning Puzzle: NULL in Conditional Split Error
A little puzzle with this Error - Status and PropertyType fields do not allow nulls while other columns do ( there are about 20 columns in original expression but left out for simplicity - these are created the same way ). Any ideas how to solve it [Conditional Split Filter Changes [813]] Error: The expression "LOOK_Status != Status || LOOK_PropertyType != PropertyType || (LOOK_OfficeName != OfficeName || ISNULL(LOOK_OfficeName) != ISNULL(OfficeName)) || (LOOK_OfficeID != OfficeID || ISNULL(LOOK_OfficeID) != ISNULL(OfficeID)) " on "output "Listing Changed" (885)" evaluated to NULL, but the "component "Conditional Split Filter Changes" (813)" requires a Boolean results. (My wish for nex ...Show All
HarveyC123 Jet.OLEDB.4.0 and Linked Servers (SQL standard 2005 on Win2003 SP1)
I have been trying to figure out for some time why Linked Servers do not continue to run. I start up my SQL Server Database service, and then using SQL Server Management Studio I create one or more linked servers to Microsoft Access Databases using the Jet Provider. I then run some queries to that access those linked servers without any problems. (One currently is called 'THE') After some time has passed, possibly minutes, hours or days, I can no longer access any of the linked servers. No data, queries, tables, or anything is accessible to me anymore. I use this command "EXEC sp_testlinkedserver N 'THE' " to test the linked server and get the following error msg. OLE DB provider "Microsoft.Jet.OL ...Show All