Pleasure.

Just declare your variable as nvarchar(max), otherwise you risk truncation.

There's no way to disable an index in SQL 2000. You'll have to drop it.

If there is a non-zero wait time in the wait_time column and there is a non-null wait type in the wait type column, then this column gives details on exactly...

https://www.sqlpass.org/Summit2008/Pages/default.aspx

Are you planning on going this year?

It doesn't have to be unique, but it it's not, SQL will make it unique behind the...

Selects by themselves cannot cause deadlocks at the default isolation level. A deadlock requires that two connections are holding and wanting locks on resources such that each connection wants a...

Not using helptext, but it you don't mind using a query rather, this will work.

Select name, definition

FROM TheOtherDB.sys.sql_modules sm inner join TheOtherDB.sys.objects o on sm.object_id = o.object_id

where name...

The WHERE should be an ON

CREATE TRIGGER On_Delete

ON tblActivityArchive

AFTER DELETE

AS

BEGIN

...

And if you do decide to go ahead, make sure you exclude any logins used by the SQL engine and SQL agent, and also the cluster service (if it's a...

Jeff Moden (4/14/2008)

---

Gail,

The country "Code" has to match the first 1 to 3 digits of either the ANI or the Dial_Digits. You wouldn't know that unless you've worked with...

jitendrapatil2006 (4/14/2008)

---

and now i want to create a view which can have start_date_time , dialed_digits , rounded_durations , cost , country , code , Rate /Min coloumns . so...

How are the two tables related to each other? How do you tell which starting date goes with which country?

Can you give a few rows of sample data and what...

How are the two tables related to each other? How do you tell which starting date goes with which country?

Please take a look at the following article for suggestions on...

I'm very much hoping to attend. Though, since I'll be 4 months into a new job at the time, it may be a little tricky.

Are there any strange messages in the SQL error log from about the time that the database goes unavailable?

What errors do you get if you try and access the DB?