It's a number, so they're the same thing. Depending on where the IP addresses come from, they can be in any form.

Here is some code that I hope will help you:

IF OBJECT_ID('IPAddressToInteger') IS NOT NULL

DROP FUNCTION IPAddressToInteger;

GO

-- Deterministic version of Denis Gobo's function

-- Parsename is not deterministic

CREATE FUNCTION [dbo].IPAddressToInteger( @IPV4Address...

Be careful: won't work for addresses represented with leading zeros, such as 128.134.002.101

IPV4 addresses are represented as strings in the dotted format, but they're integers (bigints precisely).

You can easily convert to bigint using the function provided by Denis Gobo here: http://sqlblog.com/blogs/denis_gobo/archive/2008/10/05/9266.aspx

CREATE FUNCTION...

This should be everything you need:

SELECT source_IP = dec.client_net_address,

source_Machine = des.host_name,

Database_Name = DB_NAME(des.database_id),

Connection_Time = des.login_time

FROM sys.dm_exec_sessions des

INNER JOIN sys.dm_exec_connections dec

ON dec.session_id = des.session_id

Products such as RedGate SQL Search[/url] and Apex SQL Search seem to be the most reasonable way to skin this cat.

If you have to do it with T-SQL, a...

Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1690345.aspx

Without seeing the code or the underlying database schema, the only suggestion I can come up with is: don't allow duplicates with a meaningful UNIQUE constraint.

It would be really...

You have to figure out what's wrong in the upgrade script and fix it. There's no other way around it. Your ERRORLOG should show you what's wrong.

dwain.c (5/28/2015)

---

On the CELKO ban, interestingly I just got a notification email the he posted to Jeff's article: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

But when I...

Looks like an interview question.

If "recreate table" means that all the data is reinserted in the table, the possible answers are:

ALTER TABLE SomeTable REBUILD; -- Rebuilds a heap...

You can, but it's a recipe for disaster with large data modifications. A trigger is much more...

I suppose he's attempting a comeback and being banned again.

Perry, thanks for the information. I was not aware of this issue.

I'm under the impression that the OP just wants to know if he can use the evaluation setup kit...

Confirmed. During the setup, you can enter the key you purchased instead of selecting "evaluation".