Try looking up the cast/convert function in BOL.  Try doing a little reading every once in a while before posting questions for things that can easily be found in the...

Does the user which is specified as the SQL Server service startup account have access to this directory?  If you are using the system account for the startup account, you...

Gracias Amigos.

Probably just as a varchar(xx) datatype.

have you tried RedGate SQL Compare?

http://support.microsoft.com/default.aspx?scid=kb;en-us;47048

You could create a view of the table that you do not want him to have access to and then change the grant inserts / updates to the view and...

Mucho Gracais!

One thing I just noticed is that if you create the procedure via Query Analyzer rather than Enterprise Manager it'll work fine (as long as ANSI NULLS is ON in...

I had a similar issue with attempting to use the OPENROWSET function within a stored procedure.  What syntax are you using to access this Linked Server within your stored procedure? ...

None of my servers were clustered.

I have been running SQL 2000 SP3 with Windows 2003 (upgraded from 2000) for about a year now in production.  I know of no issues, in fact I got about...

I have a very similar application / database where the users have db_owner, and I can tell you that one of the thing you may want to investigate before continuing...

The query execution plan is different than the compilation of a stored procedure.  The execution of statements in SQL Server consists of two phases: compilation and execution

The query plan is...

Thanks Phil!  I appreciate your help.