Answer Questions

• KitGreen Customizing the report scheduling...

  one of the requirements is that if the report takes a long time to run the user can start report processing and later when that report is processed user can see that in his 'My reports' section, What will be the best way to do this, my main concerns are - 1 How can I use scheduling to accomplish this. 2 How to save the report, as snappshot or what... 3. How can I find in my Web app. that report is ready or not and show a link to it. There isn't an easy way to know how long a report will take to run if this is what you after. Other than that: 1. Sure but scheduled reports have limitations. Since they run in an unattended mode, they cannot use User!UserID and all parameters must have defaults. 2. I would see if s ...Show All

• micronax "Static variable" in function

  Hi! I have a function that uses a constant value on its calculations. This value is defined on a table. I don't want to query this table everytime I call the function (I call it on a loop from my Java code). Is there anything like a static variable I could use Thank you! No. There is no such functionality in TSQL. Your approach sounds fine. Alternatively, you can define a scalar UDF that returns the constant value instead of storing it in the table. ...Show All

• nibsi remote connection problem with sql server express

  Hi have sql server express 2005 installed on a laptop running XP sp2 with IIS installed. installed sql express during the visual studio 2005 install having problems with remote connection errors messages when using aspnet_regsql.exe as well as when trying to view pages with sql db involved. in most tests to fix this i disable my firewall, still getting error messages tho sqlBrowser is running as is sqlexpress in services both on auto in the surface area configuration tool, the remote connection is set to local and remote connections is using both tcp/ip and named pipes. in sql config manager- shared memory, tcp/ip, and named pipes are enabled for both the server and the client, the order on the client is shared memory then t ...Show All

• Javier Martinez Display first non NULL value from my dataset?

  Hello, I would like to display the first non null value from my dataset, is this possible I am aware of first() and last() but what are my options for displaying the aforementioned Thanks much! John What you may be able to do is create a Matrix that has a Data Region level filter, which filters out the unneeded rows. The Matrix should contain just a data cell, with no added Rows or Columns. (In the Report Designer, it should contain a default dynamic row and column with groups containing no group expressions and empty textboxes.) And the data cell is the textbox with the expression using the First Aggregate function. Ian I'm not sure if you want to exclude the row completely or for a partic ...Show All

• OrpheusTheBard Deleting leading 0's in numbers stored in a text field.

  I am trying to use several tables that have one 10-character text field in common. Most of the records have a numeric expression, but some tables have leading 0's, and some don't. I can't cast the field to numbers because there are some records that have letters also. What function can I use to get rid of all the 0s at the left of each record (Sort of a LTRIM function that gets rid of 0s instead of spaces). Thanks! While I am not aware of any built-in function to perform this (maybe a good SQLCLR function candidate :) ), this TSQL will work as tested below... declare @Field varchar ( 10 ) declare @i int set @Field = '000123405' set @i = 1 --remove leading 0s if charind ...Show All

• etones Generate Report Query

  Hi every body the image below describe entity relation diagram of my database i need to Write Query the generate report of licensed buildings (that has license saved in BuildingLicense Table ) and not licensed buildings in section or street i need to gerate report like table below Finally i find the Answer -- ============================================= -- Create Report of Licensed And Notlicensed Buildings in each Street -- Auther Mahmoud Abd El Hakeem 09/02/2007 -- ============================================= IF EXISTS (SELECT name FROM sysobjects WHERE name = N'LicBuilPerStreet' AND type = 'U') DROP TABLE [LicBuilPerStreet] GO SELECT Street.id AS [Street], [Count Of Licensed Buildings]= ( SELECT count(B ...Show All

• nobugz Backup/Resto Restoring to new server without rerunning a snapshot

  I am designing a solution that utilizes replication from a front-end database to a back-end database. Historical data will be truncated from the front-end database in such a way that these truncation deletes will not be replicated - thus, the back-end database acts as a historical archive for the front-end database. I am concerned about backup and restore scenarios for this environment. Once we have begun truncating data from the front-end database, we will never be able to re-snapshot the database to rebuild the back-end database. My concern comes if the servers are destroyed and the environment must be rebuilt. For SQL Server 2000, Books Online says: "When you restore a backup of a replicated database to a server or d ...Show All

• Claudes Installing SQL Server 2005 - Vista help..

  Ok ive tried looking everywhere for a solution but i just cant find one... please help me I need to install SQL Server 2005 (for reporting services mainly) on Vista, but i have issues. I have installed IIS and its checked in the pre-installation checklist, and the only thing with an exclamation point is the OS which is to be expected. The issue im having is that when i get to the screen to select the features/components i want to install, they are all disabled apart from "Workstation components, Books online etc..." Where am i going wrong with this.. I know i need the services pack to install reporting services, but i cant install anything at this point. A walkthrough or something would really help... Thank ...Show All

• kenambrose No of package runs using Checkpoint file

  hi everyone, Is there anyway to find out the number of runs of a package using its checkpoint file Or is there anyother way to figure out the number of runs of a package till it gets succeeded Thanks in advance, Praveen Dayanithi wrote: Hi, Thanks Darren..thats a good way of looking at it. Could you tell me how can i get that count value into a global variable Thank you very much, How about using a package-scoped OnInformation eventhandler that looks for the eventID in question (I don't know what the eventID is but it won't be difficult to find it out) and increments a package-scoped variable -Jamie Hi, Thanks Darren..thats a good way of looking at it. ...Show All

• Catalin Zima Calling commands from the cmd prompt

  I have a series of commands that I need to run which decrypt, unzip, and rename They are all one line commands when entered on the cmd prompt, is there an easy way to do this in ssis or should i write an exe and call them from there Thanks What about calling a simple command like ren (rename) ren oldfilename.txt newfilename.txt It's not possible to select cmd.exe as the executable and enter the rest as arguments. Any Thoughts Thanks I have, when I do I get the following error Error: 0xC0029151 at Positions Unzip Task, Execute Process Task: In Executing "C:\Program Files\GNU\Gzip\gzip.exe" "-dc F:\location\20060831.filename.gz.file > F:\location\tes ...Show All

• Chrismanster How do i measure bandwith usage for merge replication SQL 2005 to Sql server mobile 2005?

  Hi, Is there any way to measure bandwith usage during merge replication between sql server 2005 and sql server mobile 2005 running on a cradled wm5 mobile device. Attaching the windows performance monitor to the network connection established over usb would work although I was wondering if there was something specific for this case integrated into Sql server 2005 / sql server mobile 2005 / Sql server management studio / third party tools that i could use thnx, pdns. Not for mobile, but if you had a SQL Server subscriber (Dev, Ent, Std, Express) you can add (unsupported) merge agent parameter "-T 101" which will give command-line output statistics for that particular sync, there mig ...Show All

• Ameeta Garga Serious error in RS licensing docs on MS web site

  Correct me if I'm wrong... There is a potentially costly error in at least 2 Reporting Services 2005 licensing docs on Microsoft’s web site. They fixed the docs a few months ago after I called and told them about it but, now they are bad again! Here are links to the bogus docs: http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx Both of these docs say that you need 2 SQL licenses to run Reporting Services 2005 on a separate server from the SQL engine. This is not true. You only need 1 license! You do of course need the correct number of CAL's or a CPU license. The license.txt file that ships on the SQL Server 2005 standard edition ins ...Show All

• OmegaMan Recompile SQL Task with Data flow task

  Hi, I created a package with SQL 2005. The package gets the Access DB and then inserts it into SQL Server. If I open the package in .NET, I can see the SQL Task and Data Flow Task. The SQL Task has a property sqlstatementsource, which has the necxessary SQL code to create the tables. How can I tell the SQL Task to recompile the SQL code if I give it another DB name, because the tables differ and don't map in the Data Flow Task Thanks Thanks for the reply, I didn't mean recompile directly, just like update or refresh or something. I can change the SourceOLEDB with the new path to the Access DB, but like I said, the SQL Task has to then recreate the SQL statements for all the specific tables in the new ...Show All

• Haiping estimating size of datable / database

  are there any rules of thumb for estimating database size / datatable size. I don't seem to find any specifically for SQL2005 hi, a good "start up" article on that can be found at http://www.sqlmag.com/Articles/ArticleID/50257/50257.html , by "Notre Dame SQL Server" Kalen Delaney, where she digs into lot of new catalog views to see where data is stored in the SQL Server 2005 architecture... but it's available for SQL Server Magazine subscriber only... regards Check out: Estimating the Size of a Table and Estimating the Size of a Database on MSDN. Mike ...Show All

• Kur Lan Unit Testing

  Well was wondering this weekend. How do you do unit testing with SSIS Is anyone trying it What are you doing and do you have any suggestions Hi Ash, would you mind expanding or give an example on the 2nd approach you mentioned - ''A directory of SQL scripts to run after data flow is done. This is typically done with a foreach file loop over sql script files in a directory tree" Thanks in advance. Anyone have any links to the MS way to do unit testing   It's the first topic in 70-441... I've been reading about this but haven't done anything yet. Here are a couple of things I found: There is a section of a paper on MSDN about this, i ...Show All