i was not thinking about the least previlages and selected the sysadmin role. thanks for the good question.

There is no problem running the sql and the agent under two diffrent accounts.Local System is a very high-privileged built-in account i am not sure why you are facing issues...

nothing intrest in this Question. if you strictly follow the Question then the answer shoud be 0 as there is no select statements to return the records. but if you...

you can connect only if you install cumulative update to SQL Server 2005 SP2

Hey there is some mismatch, i know it is datacenter and enterprise.How come the answer is Wrong.some Problem with the options :w00t:

thanks for the good question but informative one

learned something today from this Question. thaks to steav

may be You can think of doing it using an ssis package where parallel processing is possible. or you can think of scheduling a job which will in turn executes...

I was got confused with the answers, i selected NO as i thought it is the correct answer 🙂

Welsh Corgi (5/25/2011)

The following works?

DECLARE @F54 AS int

SET @F54 = 1668541.0023

SELECT CAST(REPLACE(@F54, '.', '') AS int)

-----------

1668541

(1 row(s) affected)

What is the...

What You need to do is to take the Dataflow task in the Control flow tab and go to the Dataflow Tab

In the Dataflow tab You need to select the...

This URL is having an exaple for You

http://weblogs.sqlteam.com/mladenp/archive/2007/05/17/60209.aspx">

http://weblogs.sqlteam.com/mladenp/archive/2007/05/17/60209.aspx

Good Question and nice to know about the bug in this function.

may be you can use some thing like this

select substring(column1,patindex('%[^0]%',column1),8000)

from Table1

Basically the design of the table is Wrong,i am not sure what is the perpose of this type of column

you can try like this

Create Table Table1(column1 nvarchar(10))

Insert Into Table1...