Hi,

This article is based on a new feature introduced in SQL Server 2008. It is not available in SQL Server 2005.

regards

Jacob

"dtexec.exe" can be used to execute an SSIS package from command prompt. If you want to execute an SSIS package from a stored procedure, one option is to create a...

You can run the following query to see the queries/procedures currently being executed.

select object_name(objectid) as ObjectName,

SUBSTRING(st.text, (statement_start_offset/2)+1,

((CASE statement_end_offset

...

I did not understand the question. Are you trying to track the execution of stored procedures?

cast the VARCHAR value to DECIMAL and then cast to INT.

DECLARE @t TABLE (data varchar(10))

INSERT INTO @t(data) SELECT 'abc'

INSERT INTO @t(data) SELECT '5'

INSERT INTO @t(data) SELECT '7.0'

INSERT INTO @t(data)...

You can use COUNT(*) OVER ('') to get the total count.

For example:

SELECT

name,

count(*) over (partition by '') AS TotalCount

FROM sys.tables

I dont think there is a way to add any custom scripts to achieve this. Wait for a while and see if some one can give a hint on...

And it would be helpful if you can post a repro-script.

You are welcome!

Cheers

How many seconds does it take when you execute it from SSMS with a sample XML document?

Also, make sure that you release the document handle before you exit the...

Why do you want to do that? Probably there must be other ways of achieving what you are looking for. What is the reason why you need such a feature?

One option is to run "sp_lock" which returns a list of all the locks currently active.

Where is 'date2' coming from? Is that a variable?

It is not advisable to apply a function over a column in your WHERE clause. For example

WHERE date_column BETWEEN '2008-01-01' AND...

try this:

DECLARE @dt VARCHAR(10)

SELECT @dt = 'AUG2007'

SELECT CONVERT(VARCHAR(6),CAST(LEFT(@dt,3) + ' ' + '01 ' + RIGHT(@dt,4) AS DATETIME), 112) AS DT

/*

DT

------

200708

*/

Do you always want to run the query for a single ID? Or do you intend to run a single query and get the result for all the IDs? If...