google is your friend for Error 91:

ukarlink (6/30/2010)

---

Private Sub Form_Load()

Dim cnThisConnect As NEW ADODB.Connection

cnThisConnect.ConnectionString = "data source=YourServer;initial catalog=SandBox;user id=DaveTheDeveloper;password=NotARealPassword;Trusted_Connection=False;Application Name=SSCExample.YouApplicationName.exe;"

cnThisConnect.Open

Dim rcdCompanies As NEW ADODB.Recordset

Set cnThisConnect = CurrentProject.Connection

rcdCompanies.Open "tblCompanies", cnThisConnect,...

from where? via TSQL in SSMS,SSIS, or command like via sqlcmd or maybe even an application like vb/vb.NET?

TSQL is a little hard to do, because of security issues....would...

this is a setting in SSMS; by...

freshcrop2010's post is Spam. Reported. No replies please. bot joined and posted within the same minute(second?) of the forum join.

Joined: Today @ 12:43:26 PM (0 visits since)

Local Time: 7/1/2010...

there's another thread on a very similar subject today:

Retrieving Large Videos

15-20MB in a varbinary(max)

that you should read...

basically, the filesystem is almost always faster than SQL for storing...

i would just add a datetime field with a default of getdate to each of the 4 or 5 related tables...then i'd use a view to pull the common parts...

I've seen it done a few different ways...in Quicken for example, every item has a memo field, so an additional description can be added to each item; Also it's possible...

well...first there's different KINDS of dba's...developer dba work with code objects, and tuning, Server dba's(well that's what i call them) work mostly with maintenance/backups and tuning

then there's the business analyst...

the only thing I can think of off hand is whether it was possible the server ran out of disk space after backing up the 30th database....when it moved to...

why not use a VIEW that is nothing more than a UNION ALL of the three tables in question?

then the view will never be out of sync, and will have...

i thought table variables were exempt? i know if they are in a transaction, and the transaction is rolled back, the table variable is unaffected...does that mean it's not logged,...

it's not access to the exe.

once again, the point i'm making is the exe trying to use the security context nt authority\system for example to access files or file shares....

kelvin this may or may not be much help;

i have this saved in my snippets for creating a linked server to Active Directory, and then querying it...in my case, i...

i guess you missed my point; take a look at this thread, where someone had a very similar issue to yours.

http://www.sqlservercentral.com/Forums/Topic944084-392-1.aspx#bm944497

my point is that even though local system can access...

the issue is the dynamic SQL; if that is used in a proc, the calling user needs to have the rights to the underlying object for whatever the proc is...