DSO in SQL2005

Is it better to drop temporary tables at the end of a stored procedure? I have heard somewhere that there can be stored proc recompilation i...

My query creates a new temp table every time a report is run. I need to check if the table exists before I drop it and perform a select int...

Just a quick question , when you have a article is their any way to drop a table from a article. Don't know if it important but I'm ...

I have setup transactional replication and its going fine since some time in testing. I was trying to remove one of the tables from publicat...

I'm trying to drop a table column in SQL Server 6.5. I used the following command and got error: ALTER TABLE tablename DROP COLUMN colum...

I'm trying to drop a table column in SQL Server 6.5. I used the following command and got error: ALTER TABLE tablename DROP COLUMN co...

When a user database is created, there are 31 system stored procedures created. In one of the SQL Server security auditing questions/feedbac...