Do the following way, you may get the solution.

-> Open SQL Server Enterprise Manager

-> Select SQL Server -> goto Security folder -> select Linked Server

-> right click on it, select...

What type of word formating ? Explain in detail.

Bye..!

Kishore.P

Can you try the following link:

http://www.sqlservercentral.com/columnists/mivica/creatingapdffromastoredprocedure.asp

Bye..!

Some stored procedures were missed, like

EXEC msdb..sp_Monitor_Capture_DB_Space_Info

EXEC msdb.dbo.sp_Monitor_Email_Low_DB_FreeSpace 0.1

EXEC msdb..sp_MSSQL_Recovery_Info

Hi,

It's working very fine in query analyzer, if you want please test them.

Eg:

---

create table #test(col1 varchar(5000))

go

insert into #test values ('asdjflasjd lasjkldf asldjfklas dklfjaskld faklsdjfklasjdlf askldjfaklsjdfkl asjdkljfaskld faskljdfkljaskldf askldjfklasjdfkl asjdklf askldjfklasjdflkasjdklfjaskldj...

Hai Andrew,

You can connect from VB to SQL Server is the following ways:

1. Using ADO's

2. Using SQL-DMO

I'm giving a sample code related to ADO's

Code:

-----

Const gCnnStr =...

Very nice work done for PDF.

Please provide some comments in your procedure for declaring variables for PDF Format.