you could do it in a trigger, when some value actually gets changed, or you could create a scheduled job to periodically scan the table for exceptions, depending on how...

yeah, my code examples have been working...

yeah the error implies either the file or folder is spelled incorrectly, or the filename itself doesn't exist...extra underscore or anything like that a possibility in the name?

looks like no problem...you simply need to add that additional check to your update...

something like this looks correct to me, base don what you posted so far:

this would be the...

NJDave (11/19/2012)

---

Hello

I have a request to allow a vendor to have VPN access to my SQL Server that currently has one default instance.

The default instance contains multiple databases for multiple...

also, the actual number of fields available to query is daunting; i only grab a few myself;

but this website http://www.rlmueller.net/UserAttributes.htm has a spreadsheet that has the most comprehensive list...

yes, with a linked server.

for me, domain information is very static...we don't add new people or move people into groups very often, so I usually take a "snapshot" of the...

looks like it cannot be done;

my knee jerk reaction was to see if ALTER USER supported WITHOUT LOGIN, which it does not;

my next idea was to ALTER USER WITH LOGIN...

there is a TFS Best Practices Guide out there from Microsoft;

http://tfsguide.codeplex.com/

@6.6 meg and 496 pages, it might be a bigger bite than you care to tackle.

here's a worst kept secret:

for any question that is not today's question of the day,

the answer is in the newsletters:

so if you were looking at the QOTD for Monday,...

man you must be quick!

i posted my answer, and noticed i left of the .png on the image name and fixed it right away...

glad i could help!

you probably never notice, but SSMS builds a default connection string that points to a specific database, like master, unless you selected or left <default> in place , so...

you can create a linked server to point to an excel spreadsheet, and then reference it just like shanghaigirl-1125377's example.

here's my detailed notes and example on getting it set up...

here was my test...i made a cross database synonym in one database,a dn then a procedure in the same database as the synonym:

create synonym MymasterView for SandBox.dbo.VW_FIXEDWIDTH

create procedure pr

as select...

i *think* this would give you a list of dependancy items that reference an existing synonym in a specific database.

note you can have global synonyms/ cross database synonyms in the...