Unfortunately as long as the table is part of the database file you cannot burn just it to disk. It will have to be copied to another file. If you...

I am confused, can you explain what you are trying to do. Seems like you want to call a DLL as an extended stored procedure? If so then you have...

You will need to export to another location such as another db, access db, excel or text file. You cannot just backup one table out of a database without backing...

Does your Access project have a timeout in it? I have queires that run to 3 or more mintues and never see timeouts. Something has to be causing the timeout...

Looks lke you have 2 options, one is to use a cursor to loop the records and insert when you found the pieces. 2 create a temp table with an...

Let us know what happens, especially if you get an error so others can know for sure based on experience.

"Don't roll your eyes at me. I will tape them in...

Try then doing a trace with profiler to see if you can catch what is going on or if the problem is trying to connection to the DB.

"Don't roll your...

What is you error message when it fails and you have to retry?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

From BOL

LicenseType

Mode of this instance of SQL Server.

PER_SEAT = Per-seat mode

PER_PROCESSOR = Per-processor mode

DISABLED = Licensing is disabled.

Base data type: nvarchar(128)

NumLicenses

Number of client licenses registered for this instance of...

Unfortunately Application Roles are the only way to override a users permissions. You cannot change as you suggest with an SP without giving their ID rights to change their permissions...

I have not heard of any issues. The server is not making any changes to the structure. However I do suggest testing first no matter what is said. The worst...

Try something like this...

CREATE TABLE tempX (

[vals] [char] (5) NOT NULL

)

TRUNCATE TABLE tempX

DECLARE @test-2 AS VARCHAR(20)

SET @test-2 = 'This is only a test.'

WHILE LEN(@test) > 0

BEGIN

INSERT INTO tempX (vals) VALUES...

The only other way I see to avoit the extra SELECT statement is to make a varibale for each itme in the SELECT then do yuor SELECT first like so

SELECT...

Yes you must have a SQL server instance running to connect to to be able to create a DB. And yes it will work under XP.

"Don't roll your eyes at...

I agree with ANdy and suggest if the changes move quickly is important look at updating subscribers option.

"Don't roll your eyes at me. I will tape them in place." (Teacher...