The SQL server is behind the firewall.

The developer said the web server is outside of the firewall. ( I doubt this is right or not)

Should the web server be outside...

roryp 96873 (7/30/2012)

---

ISNUMERIC will return a 1 if the value that is being tested can be converted to a int, bigint, smallint, tinyint, decimal, numeric, money, smallmoney, float, or real...

And I got the same result.

But for the isNumberic option, what I am wondering is the column data type is varchar, how come the result of isNumeric turns true for...

Thanks, it is very helpful. What if I want to include Null?

Also is this doing the same thing?

select * from table where ISNUMERIC(MODEL)=1 OR Model IS null

Thanks

And then you have those of us on the other end of the spectrum. I prefer to have individual backup processes. Gives me better control of when the...

Thanks, I know how to check collation from SSMS and code.

I cannot connect to this server somehow from other SSMS client.

And on the server itself no SSMS installed, there is...

I think the update failed is because someone logged in SSMS on the server, but I tried to kill the process, it seems it cannot be killed.

so I went ahead...

I found solution from here.

Thanks

http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/2298ed3f-95c4-4b26-b099-2596f9639117

Thanks, this is very helpful information, I will find a time to read and study more into it.

This is clear to me now, thanks for the good explanation.

GilaMonster (7/16/2012)

---

Exactly that, in the context of the database restored from that backup.

Think about it.

You took backup 1,...

sqlfriends (7/16/2012)

---

GilaMonster (7/16/2012)

---

In short because you restored the database. There's no way on earth that the diff could have been based off the second full backup, because in the context...

GilaMonster (7/16/2012)

---

In short because you restored the database. There's no way on earth that the diff could have been based off the second full backup, because in the context of...

Yesterday because of time limititation, to make sure I made a full backup again instead of differential.

Today I have time to test my question posted above, I created a...

Thanks, that is a good tip too.