I would use the RETURN statement in my stored procedure to return the full count to the calling app. If you're using the SqlDataAdapter, I would declare an integer variable...

What do you mean by “However this is just not working how I expect it to”? What is it that you expect?

You can GRANT...

I would:

1. Store the report id and name in a table

2. Put a grid control on the front-end

3. Populate the grid with values from the report table

4. Let the user...

I suggest you make a copy of your project and bring up the copy in Visual Studio 2005. It should recognize that you're working with a previous version and should...

An easy way is to create a DTS package that exports the file or table in csv format then call it inside your stored procedure like:

exec master..xp_cmdshell 'dtsrun /S "ServerName"...

It could be an automatic update or patch from Windows that caused it to reboot, if your system allows auto update.

My guess is they've been replaced by AdventureWorks. You can copy the MDF and just attach to 2005.

Two processes executing the same DLL means two instances of the same DLLs running on separate threads. Each instance is an isolated process that does not know each other....