Great, Glad I could help.

Assuming all the data comes from one database, one not just return all the data in one dataset and then you don't have to jump through hoops to get it...

naga.rohitkumar (10/5/2012)

---

ya i too agree with u ALTER TRACE

but if we use default master the user can able to have access on all databases know

i mean it for...

naga.rohitkumar (10/5/2012)

---

HI jack

other than giving sysadmin or using this script

-------------------------------------

Use master

Go

Grant Alter Trace to Login

-------------------------------------

1.if we give bulkadmin and public in server role and ddladmin,db_datareader,db_datawriter in database...

Shon,

In my experience, I have gotten the error message generated by SQL Server back when using this. It's why I wrote the code. The errors I was experiencing...

How would you get a...

WayneS (8/22/2012)

---

Hey Jack - why are you dissing all of your Threadizen buddies?:-D:-D:-D

http://wiseman-wiseguy.blogspot.com/2012/08/im-speaking-at-sqlsaturday-156providence.html

4 Threadizens doing 8 presentations, and you're not seeing any of them?:w00t:

And what's up with only seeing presentations...

I haven't checked in here in quite awhile and had a couple hundred posts to read through. Not much I'll comment on so I don't stir anything up again.

I...

I over thought this one, and knew I was doing it, but still did it anyway. My thinking was that, while you do not have to define a clustered...

Seems like you should talking to your hosting provider and/or the uddeIM people. IT is unlikely that SQL Server professionals will be able to troubleshoot these errors as they...

I think you'll need to use a script component and .NET RegEx functionalisty to get this to work.

What is the restore code on the secondary server? Sounds like the code is setup to filter on a file name and would need to be changed to restore...

Have you checked the firewall on your desktop? Perhaps it is blocking responses from that port? Outside my area of expertise now, but I'd definitely start by temporarily...

Can you connect to the named instance from the server itself?

What are you entering for a server name? Are you sure you are typing the name correctly?

Is the SQL Browser service running? Without the browser service running you need to know and specify the port that the named instance is running on as well.