How to send bulk of data by email in sql server

I'm not 100% sure, but looks like you were bitten by a DBMail Wizard bug.

I described it here[/url].

I suggest that you close all dbmail wizard windows and set it up...

raghu_ktm (4/23/2012)

---

Hi Jared,

Nice to see the solution here, In may case same issue with MSSQL Linked server, do you have any idea to solve this as well !

I am calling...

This should do the trick:

-- SETUP

DECLARE @Employee TABLE (

ExamID int,

EmpID int

)

DECLARE @QuestionPaper TABLE (

QuestionID int,

...

jitendra.padhiyar (4/16/2012)

---

According to me, each database restric access is set to "Multi_User" by default. So no need to perform anything. I have one sql server instance isntalled on another machine...

I'm sorry, I didn't notice that.

Well, I guess you will have to re-install from scratch, then.

Sorry.

PIVOT can work on one column at a time.

You could pivot manually using a crosstab[/url].

If you're looking for some help on the forums, I suggest including table scripts, sample data...

Couple of questions:

1) Do you want users to connect to the same session via Remote Desktop? If so, it's impossible.

2) Do you have a Terminal Server license?

3) How does...

Developer to Standard is a supported upgrade path (see http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx).

You just have to run the setup to change the edition.

You can do that from the setup GUI[/url] or via...

It's a typical catch-all query. I recommend doing this with dynamic SQL.

See this post[/url] on Gail Shaw's blog for more info and a better solution.

Totally misread your question, sorry.

I thought you wanted to avoid the job failure...

Grant Fritchey (4/10/2012)

---

Why can't we use CLR tricks? 😛

And I hope...

GilaMonster (4/10/2012)

---

OPENROWSET

Doesn't make it good practise, can have some really fun effects (functions aren't allowed to change...

Grant, your "Depends" answers made me curious.

CLR tricks aside, how can you call a procedure inside a function?

1) Yes

CREATE PROCEDURE usp_test_1

AS

BEGIN

PRINT '1'

END

GO

CREATE PROCEDURE usp_test

AS

BEGIN

EXEC usp_test_1

END

2) Yes

CREATE FUNCTION ufn_test_1()

RETURNS int

AS

BEGIN

RETURN 1

END

GO

CREATE FUNCTION ufn_test()

RETURNS int

AS

BEGIN

RETURN dbo.ufn_test_1()

END

3) No. The EXEC command is not allowed in functions.

4) Yes

CREATE PROCEDURE usp_test_2

AS

BEGIN

SELECT ...