When you compress the database, the compressed files should be smaller then the original files. It has nothing to do with how full the database is. This is...

Every object in the database has 4 parts to his name. Some of the parts have default, so most times we don't use all the parts. Suppose that...

My way is very similare to Dwain's way, but I also added the distinct key word so there will be only 2 rows. I also didn't use the stuff...

I assume that you are using a log table and in the catch block you want to log the information. In that case you can also use the error_line()...

Bellow is code that shows how to get yesterday's date by adding to a specific date (in my example January 1, 2000) the amount of days that past since that...

The first thing that I would check is if you have blocking on the table. Both of us are not native English speaking, so maybe I didn't understand you...

I think that you didn't copy the entire code. Your first query should have a group by clause, which it hasn't.

As for your question –...

If the server is configured to log failed logins in the error log, you can get the IP of the machine that has the application that tries to connect. ...

If I understood what you want, you can join tables by id and then do it (see my example bellow), but I do have to admit that I'm not sure...

What do you mean by – "Restart one database"?

Adi

Do you always have space before the decimal point? If the answer is true you can use the replace function to replace ' .0' with ' 0.0'. Using your...

alter table MyTable alter column MyColumn varchar(1000) not null

One more option is that you had a multi-line function that explicitly used temporary tables in its code.

Adi

I...

The fast way of working around it will be to modify the function's last line, so insead of the the line

RETURN @String

it would be

RETURN REPLACE(@String, '^','')

Adi