Try it like this:

Yes, you are right,...

I have managed to contact the client and get them to look at the log. No, there's nothing untoward there at all.

Our program starts the backup and then ftp's the...

Kenneth

Just to pick up on this point you made:

"We" do use BITs quite often. They are a nice small data type where I can fit 8 of them into a...

Hi

Code to do this in VB. (I think this came from a help file somewhere)

Function FindServers() As DataTable

Dim instance As System.Data.Sql.SqlDataSourceEnumerator =...

Apart from that, what's going on with the transaction? Nobody's mentioned that, but isn't that kind of weird? (Don't shoot me if it's obvious, I'm primarily a .Net guy rather...

mp - As a bit of reassurance - your Epilogue is spot-on. You're not the only person to find the lack of time-only and date-only data types in SQL Server...

Another thing to be aware of - are you sure that all the applications that use this db were written with declarative RI in mind? Because if not, you may...

Thanks guys for all of your suggestions - I knew if I posted on here I'd get some good advice!

pg

Well, for that very reason, the data would not be entered by an HR data entry clerk.

I don't want to get too involved in the details of the scenario,...

Thanks for this reply but it's not really appropriate. The system we're developing is similar to say a small system for an HR dept - details of salaries, sickness records,...

Right - I guess I should have said 'modifying the registry directly' - the context was, I've just this minute, in a support call ,talked someone thru' modifying the registry...

I thought the registry was the only way to change it too, but I've just discovered that in SSMS it's possible to select the server node, properties, security - and...

Another thing to check - Windows firewall , Norton Internet security, etc - these will all prevent communication from workstation to server.

pg

Thanks guys. I think my question could have been a bit clearer, but essentially I'm getting the message - 'Yes, you have painted yourself into a corner'

Aliasing the columns doesn't...

Thanks everyone for the replies. Some useful suggestions in there for other occasions also.

I've now managed to narrow it down a bit. Confession - there was one of those strangely...