restrict access to database

Hi all, i am very interested on sqlprogramming, i want to see the #temptables data in Query analazer, and i want to create a log files that ...

Hi all, i am very interested on sqlprogramming, i want to see the #temptables data in Query analazer, and i want to create a log files tha...

I am dissapointed that script options are missing in Management Studio. I never understand why a good feature goes away in a newer version. ...

I am dissapointed that script options are missing in Management Studio. I never understand why a good feature goes away in a newer version....

I am dissapointed that script options are missing in Management Studio. I never understand why a good feature goes away in a newer version. ...

I have a very large table that is refreshed periodically. Since it's so big, I do a 'drop table', 'create table', 'c...

Is there any way to script Databse Role(s) and Role Memeber(s) using SQL-SMO? The workaround i am using here is, set the server connection e...