That is an interesting issue. I can't seem to see a way to force your syntax to be smart about it.

Of course - my next reaction was...

The answer to that is 42...

I am not sure you ever will be able to. SQL Server 2000 had a specific prohibition against allowing you to use anything non-deterministic in creating a user-defined-function. ...

It's very likely being blocked by the hosting company. Opening the ports you need would be a hacker's heaven - meaning - a wide open avenue right into your...

Technically - no. Pivot entails an aggregation operation.

Of course - an aggregation on a group of 1 would usually be the same as no aggregation at all. Try...

Just curious - when you say "from outside" what do you mean? Surely you don't mean - from your machine over the internet?

That 5 and 8 mean invalid user...

You need to go dig up the ACTUAL error from the SQL Server error logs. It would look something like:

2008-02-22 12:37:41.46 Logon Error:...

Andy - what's the rest of the error message? This link actually might help you decipher what the server is trying to tell you....The "state" listed is actually giving...

Agreed - dump the stuff to a table, and notify them somehow that the stuff was deleted. Preferrably don't put the e-mailing in the trigger, since you don't...

And remember - they're "illegal" unless you put them in a CDATA tag. At that point pretty much anything goes....

wpp9786 (2/22/2008)

---

Pretty basic question ... I've been researching for hours. All the examples I have found seem to be exclusively for system tables whose columns are in syscolumns.

How can i...

Functions don't get used with that particular syntax which is probably why you're having trouble. EXEC is for a stored procedure.

Try -

select 1, 2 from x

union

Select [3],[4] from...

The root directories of machines are usually secured more stringently than other folders. The proxy account doesn't have the permissions.

You running the BCP command from a command-line...

Sometimes you have to go looking for Karma. Or rather - go hunt it down, shoot it and nail up on the wall for all to see.

There are ways...

Jeff Moden (2/21/2008)

---

One more thing... the ticketing system should have the concept of "Parent Tickets" and "Projects" associated with it. Seriously, this is the only way to keep a...