Hi Atesim et al,I have used sp's for a long time so am relatively familiar in some respects with the power of SP's. To clarify my "query", I am...
Thanks All. I thought as much. I didn't design this table but stumbled across it and wondered why a PK had been left out. I thought it may have been...
I have a table which is purely used for creating many-to-many relationships, hence all fields are foreign keys of other tables. Should I still...
Hello, We are in the process of familiarising ourselves with SQL 2008 having spent a number of years using 2000. My previous understanding was that...
MohammedU, I am using Sql Server 2000, sorry about the typo... LuisMartin, all databases are backed up every night via a scheduled job that runs the...
I am using sql server 2003. I have several databases and am using all 3 recovery models. I have noticed that in the case of the databases using...
Thanks for the advice. The model db seems the way to go. I am currently working through the issue with our hosting centre as to why our server has...
A particular application which connects to an instance of SQL that I administer, performs bulk inserts into the tempdb. As such the appropriate...
Thanks for that - I was obviously thinking too hard. That's pefect. Cheers
I was hoping someone may have some advice for how I can ensure the SQL Server Agent starts automatically with SQL Server 2000. I have some scheduled...
The login is not a member of any of the server roles. Thanks again.
Thanks for the reply. Select permission is not being denied for any logins or server roles on the tables in question.
Hello, I've been trying to adhere to the best practice of confining all access to data to stored procedures. So for example i have some simple...
Separate names with a comma.
