Does the following code work?

USE master

GO

CREATE USER jondoe FOR LOGIN jondoe

GO

GRANT EXECUTE ON [sys].[sp_OACreate] TO jondoe

GO

I'd recommend using delimited format instead of fixed length formats, as it is a lot easier to work with.

First of all, for all your future posts read this article on how to post questions to getter better responses[/url]

Secondly, read about the article on how a tally table replaces...

It can be done by adding two separate workflows for each of the files. And also to check for existence of a file you need to use ActiveX Script...

Heard about UNPIVOT clause in SQL 2005? This is where it can be used.

DECLARE @tblMessage TABLE

(

Id Int,

Description Varchar(50),

Message Varchar(256),

colName varchar(20)

)

DECLARE @tblError TABLE

(

ErrorNumber Int,

Variable varchar(20),

ABC varchar(20),

ABC1...

Yet another running total problem, follow this link that explains the 3 methods on how to calculate running totals.

For advanced method (i.e. Special Update method), see this article[/url] by Jeff...

veen_computers (5/16/2009)

---

Hi Ramesh,

Thanks for the solution. We have .net 2.0, Sqlserver 2005 reports environment. Inorder to perform this i need install this soft in Client's server machine.

So as u...

I use RSS Scripter to export all objects (includes data sources, reports, folders etc.) from a report server. Here is that download link

See the following links

http://www.mssqltips.com/tip.asp?tip=938

http://www.intelligententerprise.com/001020/celko1_1.jhtml

That's not a bug, but indeed the intended behaviour of the operations "Move file" & "Copy file". These operations does...

Another way, should perform a little better.

SELECT AnalysisA, sum(COST) AS SummedCost, cOUNT(* ) AS TotalAnalysed

FROM #Product

GROUP BY ( CASE WHEN AnalysisA = '' THEN CONVERT( VARCHAR(40),...

I don't see any problem in creating N users in any database, actually it is a better practice to grant only the permissions to users which they require and not...

See the following link:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=DuplicateRows&referringTitle=Home

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6256

To create a SQL Server Agent job, a USER need to have execution permissions on objects

1. Execute sp_add_job to create a job.

2. Execute sp_add_jobstep to create one or more...

You are welcome, and for all your future posts read this article on how to post questions to get better answers[/url]