You can shrink the database by using dbcc shrinkfile command. BOL has details about it, but if you don’t have any space problems on the disk, maybe there is...

Your post is not very clear because it is hard to know if both queries produces the same values in the common columns (the columns that come from table1 and...

TempDB is used by the server for operations such as storing temporary and work tables, ordering records, storing records’ versions, etc’. If the TempDB is growing, then the server...

SQL Server 2005 standard edition supports working with awe, so you can enable your server to work with more then 2GB. BOL has some articles on how to configure...

You can do it with sp_rename. Just make sure that the third parameter is column. You can check for more details in BOL.

Adi

Here is one - http://www.sqlservercentral.com/Forums/Topic638875-145-1.aspx.

Notice his second respond after Steve’s and Garadin’s request from him. By the way one of the things that I can’t understand is...

I don’t think that a commit statement is missing. I think that if there is a runtime error in a trigger, the whole transaction has to be rolled back....

TDP (1/19/2009)

---

You would think that if you cannot shrink the file below the initial size they'd at least give us the possibility to be able to decrease the initial size...

I’m sorry but I’m a bit confused here. As far as I know system objects are stored in the resource database which is a read only database and users...

While I agree that giving the login sysadmin privileges will make your problem disappear, I don’t think that you should do it. Giving the login sysadmin privileges will give...

I guess that you are doing something wrong. Bellow is a small script that creates a procedure in the model db, then creates a new database and shows that...

Check if the user belongs to a group that has deny permissions on insert to this specific table. In case of such a conflict, the deny takes precedence over...

You are grouping the results by the value of the date instead of grouping them by the month. If you have records from the same month but they are...

This is taken from Microsoft documentation: “…you can change a computer named MB1 that hosts an instance of SQL Server named Instance1 to another name, such as MB2. However, the...

I don’t know what the problem is, but I don’t think that it is because of permissions. If a user has no permission to work and see any table,...