That's the thing, I'm not a DBA, I'm a developer and I use SQL everyday but the "security" aspect of SQL Server, that's new for me.

The server as been...

I didn't know about the stored proc "Sp_helprotect".

Thanks for the info, that helped a lot.

That works but is it normal that when I connect with this user I still see the master and tempdb?

Is there a way to remove the user's access to the...

Have you tried using a format file with your bulk insert. I use something like this :

BULK INSERT TBL_CLIENT_TEMP FROM ''x:\path\FileToImport.txt''

WITH (FORMATFILE = 'x:\path\FileToImport_Format.txt'', DATAFILETYPE = ''char'',

FIRSTROW = 2, KEEPNULLS,...

You can also use the BULK INSERT command with a BULK Format file.

http://msdn.microsoft.com/en-us/library/ms179250.aspx

SELECT REPLACE(STR(123, 9), ' ', '0')

generates an output like this...

000000123

Thanks

JStiney,

Can you post this script?

Thanks

Everything works better when you're KIS'ing, as a developper I can tell you that keeping it simple doesn't mean to write simple code. You can build something and work hard,...

Do I need to backup the system databases?

I'll go with the differential backup daily and the full backup weekly.

The transaction log, depending on the database and its purpose can go from hourly to daily.

Thanks Jack for the...

Useful links :

http://palisade.plynt.com/issues/2006Jun/injection-stored-procedures/

http://www.sqlmag.com/articles/index.cfm?articleid=42216