Thanks for the references. I am reading through them and the book 'SQL Server 2005 Unleashed'. I am confused about when I should try to create a...
I am want to setup some constraints on database users in SQL Server 2005. The application will require that users can: execute stored procedures (but...
Thanks. I will look at this on Monday when I get access to the machine.
Yes, the temp tables are created with the # in front of the table name. I thought that all logins are granted access to tempdb, but for some reason...
Thanks for the reply. The tempdb is used for temporary tables only. The error appears to be generated when a stored procedure in the main database...
I have an issue with SQL Server 2000. I am taking over maintenance of a set of databases at different sites. Each site has multiple databases, with...
Separate names with a comma.
