man, if at all possible, change your columns to true datetimes immediately.

Like Sean said, one of a billion plus reasons to use the right datetime data type is headaches like...

ok, is this a special table where there is one and only one row in the table?

the reason i ask is the variable population like this:

select @cnt = percentcalled

from dbo.[StatLog]

there's...

yogi123 (11/19/2012)

---

i...

well the details would help, but roughly it would look something like this:

if exists (select 1 from VW_products

where...

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!