I have a table were I would like to store a description in a column, I want to stay away from using Text datatype since it puts the column in its own...
In the error log is there a way that I can control what gets put into it. For example it records every time a user connection was issued. This log...
Our NT administrator says that we shouldnt bother with routine back ups via SQL Server. That he backs up the all the files (Sql mdf adn ldf) on the...
On many look up tables I noticed that they contain CLUSTERED INDEXES. Provided that the statistics were out dated by far. Do you think the query...
Im executing a stored proc to test it. It works fine but when I diliberately cause in error it sends me this message. Server: Msg 2627, Level 14,...
I would like create a stored procedure to delete multiple records. The parameters are going to be passed in through ASP pages. When a user checks...
Anyone have any code I can use. Say if a field FieldA in TableA was updated a Trigger would fire that would update on another table TableB FieldA...
Separate names with a comma.
