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?

Are you using SQL 2005? If so, can you post the execution plan please (save as a .sqlplan file, zip and attach please)

My initial thoughts - 90 000 out of...

It's best to do a reindex first and never to shrink.

Databases need to have some free space within them to work. If you shrink one down to the minimum size,...

Interesting. Ok, will take that back. There's nothing wrong with having begin tran and commit in different batches though. This does work without error

BEGIN TRAN

GO

WAITFOR delay '00:00:10'

GO

COMMIT TRAN

Looks like SQL...

I wasn't speaking about the occations when yuo need a cross join. If you need a full cartesian product, then just list the tables. Dunno about you though, but I...