-
- Retrieve name of running stored procedure
by Bastiaan Molsbeck
- 4 Replies
- Last post
by Bastiaan Molsbeck
- Hello everybody,
I would like to know if there is a function to retrieve the name of the running stored procedure, like the built-in function "DB_NAME()" to retrieve the name of the database.
I need to retrieve the name for logging possibilities.
Thank you in advance!
Bastiaan Molsbeck.
-
- Issues with execute package task in SSIS
by Vivek S
- 10 Replies
- Last post
by Vivek S
- Hi,
We have used an execute package task in our master package to execute a child package and we have set the execute out of process=false. This master package is running fine in 32 bit server but is failing in 64 bit server. is there any settings to be done in the server or is it the problem with the property setting(execute out of process)
Vivek S
-
- Problem with IIF and Like comparison
by JDowdle
- 4 Replies
- Last post
by Simone
- I am having a problem with the following expression
=IIf(Fields!client_short_name.Value Like "Capital% " , 1,0)
I am wanting to get a value of 1 if the field has any of the valid values that begin with Capital but it always returns 0. Any ideas
-
- Unable to backup database in UserInstance
by MFriedlander
- 14 Replies
- Last post
by Mike Wachal - MSFT
- I've been struggling with this for a few days now, so I guess it's time to ask for help. I'm working on a VB Express 2005 Single form windows application that uses a SQL Express 2005 two table data base. I can read and write to the database with no problems. I just can't back it up. I haven't tried restores yet. I created the database in SQL Server Management Studio Express and then connected to i
-
- Long Memory Grant Queue Waits in SQL Server Express SP2 causes slow queries
by Barry Henderson
- 1 Replies
- Last post
by Mike Wachal - MSFT
- I have a 2GHZ cpu with 1GB of RAM. I occassionally see very slow (long) queries against a local SQL Server 2005 Express (SP2) database. The issue occurs against different SQL Queries, but all queries are rather basic select statements Perfmon shows that the SQL Server counter for the "MEMORY GRANT QUEUE WAIT Avg MS" gets extremely high (25000+ ms). Perfmon also also shows that PAGING is
-
- Directory variable problem
by Pikker1981
- 10 Replies
- Last post
by mj van den berg
- Hi, I have a for loop container with a File System Task that is used to move all files that start with inv (*inv). I have a string variable where I specify the directory path of the files' source and a variable for the destination. I get an error that states the directory cannot be found and hence the task fails. The thing is...that directory does exist and all the permissions are set...when I ha
-
- Getting the list of expressions from a package
by jwelch
- 3 Replies
- Last post
by jwelch
- Does anyone have any ideas on quickly getting a list of all expressions used in a package For the BIDSHelper add-in ( http://www.codeplex.com/bidshelper ) we need to get a list of all the expressions used in the package and update the list whenever an expression is added through the IDE. Currently, we are iterating through the package, and checking every property of every task to see if it has an
-
- SSIS and the Receive Command
by VDBA
- 7 Replies
- Last post
by Remus Rusanu
- I built a system where I am sending batches of messages using a single conversation. I want to pull these messages out of my queue using Service Broker. I may have more than one batch sitting in the queue waiting to be picked up, so....
In my SSIS package i started by getting a unique list of conversation_handles where the message type is my end of batch message ( should only be one per batch).
-
- How to cancel email when have processing error in custom formatter?
by Dan Murphy At Trailmark
- 5 Replies
- Last post
by Dan Murphy At Trailmark
- We have a custom formatter that we use to format our e-mail before sending it out. We would like to cancel the sending of the e-mail if we encounter processing errors in the customer formatter. Any ideas on how to do that
-
- Dedicating CPU (Threads) for Subscriptions
by David Beavonn
- 3 Replies
- Last post
by David Beavonn
- We've invested ourselves heavily in subscription-based reporting where the SSRS service is responsible for rendering and delivering reports (to email, file shares, printers, document repositories, etc). We figured that this would be a model that would allow for easier scaling. Users submit their reports and allow SSRS to deliver them in due time. The biggest part of our reporting is now done via s
-
- SQL Disconnecting multiple clients
by Dana Comolli
- 1 Replies
- Last post
by Jens K. Suessmeyer
- We have a situation where multiple-random client connections to SQL server get disconnected.
The workstations are not consistent, the time is not consistent, and the functions being run are not consistent. One thing that we can reproduce is that sometime, but not always, if a workstation runs a function that calls a specific stored procedure (SQL native client, ADO, SQL Server 2005 SP2), du
-
- Auto Data Extraction through ODBC
by Amir Ayub
- 6 Replies
- Last post
by Arnie Rowland
- Hi,
Could you please help me to find easiest way to schedule daily auto data extraction time in SQL Server Express 2005 Edition (I need to put time to load data every day).
Thanks
Amir
-
- User on trusted domain does have permission to access linked server on AD deployed in another domain
by Richard_B
- 5 Replies
- Last post
by Emanuel Peixoto
- Hi,
We have the followoing:
-A "master domain" AD, a "sub domain" AD, a trust relationship between the two (sub trust master)
-A sql server 2005 on a win server 2003 in "sub domain" AD
-A linked server to "sub domain" AD
-A linked server login using a "sub domain" admin acccount
-A view to this linked server
-A grant on ma
-
- Question about web reports
by rmethod
- 1 Replies
- Last post
by gnieboer
- Hello all,
I've been using SQL 2005 Reporting services for the last month or so and i love it. I just have one question.
My SQL 2005 server is located behind a firewall so i can't access port 80 to view the web reports. But, i also have another server behind a firewall that is my primary web server. How can i access the report via the web from the web server
Thanks.
Richard M.
-
- Flat file format
by 95five0
- 4 Replies
- Last post
by Phil Brammer
- I have a table that I want to export to a flat file . The problem I am running into is, the person I am sending it to needs it in a specific format. It is a comma serperated file and I need quotes on some of the data but not all. For example : "1234",abc,"id" I know how to make it all or none but not conditionally. Also I have some fields that the total in them is 0.00 and whe
-
- Using Report Builder from the internet
by ruvy
- 2 Replies
- Last post
by ruvy
- Hi
When i click on report builder
I am getting the remote server returned an error: (401) Unauthorized.
It works locally
What kind of permissions i need
I am using Windows authentication
Thanks
Ruvy
-
- Export ReportItems in header different btwn Excel and PDF
by mattcushing
- 14 Replies
- Last post
by Lisa Nicholls
- I have a sum on a reportitems cell in my header: =Sum(ReportItems!textbox1.Value) When I run the report, it looks excellent. My issue is when I export it. When I export to Excel, it looks just like it did. When I export to PDF, it gives me a total per page, not for the report. Does ReportItem behave differently when rendered between excel and PDF Or is it because I am putting a SUM on a ReportIte
-
- Question about TransactionScope and DTC
by NightElf
- 0 Replies
- Last post
by NightElf
- My Code :
Code Snippet
using (TransactionScope scope = new TransactionScope()) { using (SqlConnection sqlConn = new SqlConnection(connStr)) { sqlConn.Open(); //throw exception: The transaction has already been implicitly or explicitly committed or aborted
//do delete,update
}
scope.complete();
}
-
- Fact Table SQL Query - adding a prefix to a value
by SPeters
- 7 Replies
- Last post
by Darren Gosbell
- Hi there, I have a question regarding a query to extract measures from a fact table. The fact table from the source system contains delivery notes with turnover in one dataset. The primary key is the delivery note number plus a consecutive number. The same table contains also the cancellations of the delivery note with the same turnover and the same primary key as the delivery note, only differed
-
- Report Builder and optional parameters
by Wapper
- 14 Replies
- Last post
by elibet
- Hi,
Is it possible to create optional parameters in Report Builder
An *ordinary* parameter is created by marking a filter expression as "prompted". At run-time, the user will be asked to provide a value for this parameter (or accept a default value if it is available). This works fine. What I want is to let the user choose whether to provide a value, or leave the parameter empty. I
-
- Slow Queries: Big Dimension on Axis and Measure Using Root()
by David Beavonn
- 14 Replies
- Last post
by David Beavonn
- Here's an odd perfomance problem related to Root().
I have two queries that are very quick. Query A:
SELECT
{[Measures].[Sales]} ON 0,
NON EMPTY CROSSJOIN ([Product].[Product Code]. Members ,[Product].[Product Name]. Members ) on 1
FROM [Sales Activity for Projections]
WHERE
([Time].[Time F].[Year].[Y 2005],
[Product].[Product Type Name].[Special Produ
-
- How to transfer database to mobile device?
by twotoed
- 2 Replies
- Last post
by twotoed
- Hi all, I'm new to mobile devices.
I have a desktop application that uses SQL Server Compact Edition. I will soon have a mobile application that will use the same database. How can I (at runtime of the desktop app, say when the user clicks a button) transfer the sdf file to the mobile device I'm not necessarily interested in synchronizing the databases, simply overwriting the database on the mo
-
- SQL Server 2005: full text query failed
by fvincentis
- 13 Replies
- Last post
by fvincentis
- Hi guys, I am getting a really weird error message when executing a full-text query on SQL server 2005: ------------------------- Microsoft OLE DB Provider for SQL Server error '80040e14' The execution of a full-text query failed. "The form specified for the subject is not one supported or known by the specified trust provider." ------------------------- Just to give a bit of background:
-
- Performance problems
by tschi2001
- 14 Replies
- Last post
by Bryan C. Smith
- Hello experts,
Sorry but I¡¯ve got a problem again.
I¡¯ve got a little Cube made by SSAS2005 with just one Dimension (12 Attribute) and one Measure group (1 Measure).
I build a report with RS and notice, that I have to wait about 1 Minute before the result was shown.
My next step was to browse this forum and I founded some blogs.
After read and implements the recommendations an
-
- Transfering data from one database to another in Visual Studio 2005
by renz2k7
- 12 Replies
- Last post
by Satya SKJ
- How could I transfer database data from from one databast to another in SQL Server 2005 because I had 4 databases in my application and I want to merge all database data into one database. Thanks in advance.