here's my best guess, but i'd really need the actual table definitions and sample data, along with expected output/example to really give a decent answer.

ALTER TRIGGER

...

i have this saved in my snippets that might help...instead of a linked server you could loop back tot eh current server as well:

SELECT * FROM OPENQUERY( [linked server],'SET FMTONLY...

because you are getting responses form the mail server, you have everything set up almost perfect.

in order to prevent spam, most mail servers prevent relaying(returning error 5.7.1 Unable to relay...

Sean nice job; you should submit this as an Article as well; it will get more exposure, plus some bragging rights for you as well...you can say you are "published"!

way...

c# uses double slashes to escape and mean a regular slash; it is interpreting \s to be a special char that doesn't exist; is new line, \t is tab,...

the SMO method is more robust; there is a IsLocal

field in the set returning 0 or 1 for true/false if it is local;

you could create a CLR to return...

here's one way via TSQL, but it requires osql and xp_cmdshell:

CREATE PROCEDURE dbo.ListLocalServers

AS

BEGIN

SET NOCOUNT ON

CREATE TABLE #servers(sname...

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...