then the easiest way woud be to create an application is VSA to do this, this would mean that your spreadsheet is behaving like a front-end application

you could write something with VSA to update the database as a new row is entered.

or you could create a ssis package that read the file after it has been...

I don't really want to start...

SELECT firstname,lastname into [NEWTABLENAME] FROM Employees

Well you don't need the word 'outer'

I guess it depends, i always use left join as I like to think from the left when bulding queries, other people may...

I wouldn't do it like that, a column name should reflect whats in the column there is no need for prefixes..

I would follow Celko's advice.

you could also use data compare from red-gate

it looks like a permission issue

I would start by checking the sql server error log

I am not sure that there is an equivalent of SUSER_SNAME()

but you could possibly get the info from sysprocesses.

select hostname from sys.sysprocesses

where sid = SUSER_SID()

this is only a suggestion...

and what service pack are you running?

I have had issues like this prior to installing SP2

I usually write a webservice to call the stored procedures, then use a tool such as SOAPUI to load up hundreds of instances of the webservice at the same...

they should have an idea, even if the code is in a compiled DLL the developer who included that DLL in their code should know what it does and...

it depends on your relationship with them, if you employed them and they wrote the software for you and you own the data then they should.

you will need to ask them what kind of encyption they used and the salt values.

And assuming they used one of the standard ones, you can implement this yourself in...

it depends on how they are encrypted, if they use simple md5 hashing it is possible to convert them back if you know the salt value.

however if they are...