Answer Questions

• Keystone ServerName/Database Name Parameterization

  I would like to parameterize the server name and database name in a query inside a stored procedure. I would like to avoid using the exec(@SqlCmd) technique if possible. HELP Also, check out the link below for a discussion on pros & cons of dynamic SQL. http://www.sommarskog.se/dynamic_sql.html Nope, not in SQL. And it is not really a good idea, even using dynamic SQL. If you could do this, t ...Show All

• hedelein Privileges for Deploying Reports

  Hi Everyone, I am having problems in deploying the reports. Here is what I am trying to do 1. I have a SQL Server 2000 Database. I am using Reporting Services 2005 to prepare a report which will interact with the 2000 Database. I am able to develop the report and preview the output from the BI studio. Now, I am trying to deploy the report on to the box where reporting services 2005 is installed. I am using windows authentication and my ...Show All

• Anony22222 Urgent! Trigger problem!

  I have the follow trigger attached to table [VoucherDetail] and I want to update table RecAccount when there is change in [VoucherDetail]: Create Trigger [dbo].[tr_Account] ON [dbo].[VoucherDetail] AFTER INSERT, UPDATE, DELETE AS BEGIN  Declare  @BalanceDiff decimal(18,8),     @AccountID int,     @RecDate DateTime,     @MonthStart DateTime,    &nb ...Show All

• Alexandru Ceausu Cannot create new SQL database file.

  Hello, I'm using MS Visual C# 2005 Express, but I can't create a new local database file in the "Add -> New Item" dialog. The Studio doesn't create the database, but shows a file not found message. Any ideas Hi Bjorn, There seems to be some confusion about whether you actually have SQL Express or not. You've said you don't, but the Template Data directory should even exist unless you actu ...Show All

• dinh xuan dung June CTP - Multi Value Parameter

  I have a string report parameter with Multi-value checked. The multi-value list generated does not contain quotes around each string values. Is there a simple way to accomplish this I want to include this list in the IN of the WHERE clause. Thanks, I have been trying to pass the string values so that the WHERE column IN (@param) works. The only quotes that are generated are 'value1, value2' where as the f ...Show All

• harkat1 Adding the date to a subscription report name

  Does anyone have information on how I can add a file date to my named report when a subscription writes that file to a network folder I am exporting as .pdf files. For example, today I have filename abc.pdf but I'd like it to be abc03312006.pdf. Likewise, tomorrow's file would be abc04012006.pdf. Any help is greatly appreciated. You have to go for reporting services programming and create a subscription pr ...Show All

• Chris24 SQL server express 2005 local accounts problem. please help!

  Hi all, After working for weeks on a project in VB.Net, I decided to deploy a test version on a user's computer. The user's XP SP2 computer has sql server xpress 2005 installed, and my VB.net creation. Everything works without problem when the user's XP account is set with Administrator permissions. But when i change the user account to Limited, the program fails with the following message: "Failed to generate a user instance of SQ ...Show All

• Anders Rydén Transmission Queue problem

  " noWrap width="1%" bgColor=#b71c0c> 1. Yosi   29 Temmuz 12:19     secenekleri goster Gonderen: "Yosi" <yus ... @bizitek.com> - Bu yazar n yazd mesajlar bul Tarih: Fri, 29 Jul 2005 02:19:00 -0700 Konu: Service Broker Cevapla | Yazara Cevap Ver | let | Yazd r | Sadece Mesaj | Asl n goster | Kald r | Kotuye Kullan m Bildir I'm trying the service broker features of SQL Serv ...Show All

• Kevinkz help me....

  hi everyone i got 2 questions plz 1- how to use the datadiff function ....plz write the code 2- is there a Trim function or statment that cuts the unneeded spaces before and after the word thanx ... Hi there, 1. http://msdn.microsoft.com/library/en-us/tsqlref/ts_da-db_5vxi.asp frame=true samples imcluded :-) 2. What do you mean by unneeded You can trail characters, by using the function which I wrote some time ago: C ...Show All

• Petter Salminen cant connect

  i am devleoping an ASP.Net website now. i got a problem on connecting. when i try to connect (i manually made thew connection), it wont connect. the error is this: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'MANEC\Batman'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) I have other other webpage that us ...Show All

• Manos Kelaiditis Executing SSIS packages from client machine using SQL Express Engine

  I have few DTSX packages on my SQL server 2005. These packages are supposed to transfer data and stored procedures from server to client Express engine. The scenario is that when user connects with the server he should run some kind of utility or any other way to run those SSIS packages so that the data could be transfered. Remember the user machine has only SQL Express Engine and the packages are in SQL server 2005 machine. Can any one he ...Show All

• Chris Vance Maintanance Plan

  in the beginning i could create such plans without any problem, but since the workstations run's inside domain it doesn't work either with sa nor with system admin. any idea how i can solve that issue below you find the details of the exception i get. thanks in advance, =================================== Exception has been thrown by the target of an invocation. (mscorlib) ------------------------------ Program Locatio ...Show All

• Gary Nicol Wich datatype?

  Hi Group, Wich datatype can I best use for a number with several decimals (can be anything between 1 and e.g.10) If the number has 10 decimals the customer needs the EXACT numbers. They couldn't explain why.... TIA Regards, Sander Here you see the data types. http://msdn2.microsoft.com/en-us/library/ms187752.aspx decimal/numeric seems to be the best data type to use http://msdn2.microsoft.com/en-us/library/ ...Show All

• trk Rowcounts don't appear

  [reposted from the beta NG] Hi, I have a data-flow that, when I run it in the designer on its own, displays rowcounts in the GUI as data flows through the pipeline - as we would expect. However, if I execute the package from another package (still from the designer), the rowcounts don't show anymore. Everything goes green/yellow/red as normal - just no rowcounts. This is on IDW14. Haven't yet got IDW15 up and running. Note that on the ...Show All

• visual_newbie raw file destination and environment variables

  when using a raw file destination it would be nice to be able to use an environment variable for the filename property. like %my_extract%\data.txt instead of c:\my_extract\data.txt How did you do it, there isn't an expressions setting for raw sources/destinations. What do you do to get the filename to be based on a variable have you actually tried that ...Show All