The primary key is on col1 and col3. The check constraint is on col1 and col3 is unique in t1. Now, a value in col3 in t1 can...

For t2, col1 = 85. For t3, col1 = 86. So the code looks like:

ALTER TABLE [dbo].[t2] WITH CHECK ADD CONSTRAINT [CK_t2] CHECK (([col1]=(85)))

ALTER TABLE...

Lynn,

You are absolutely right, my apologies. What I should have asked was 'Has anyone had a similar experience?' Now, here are the details:

CREATE TABLE t1(

[col1] [int] NOT NULL,

[col2]...

Hi All,

I've been playing with a partitioned view I created all day long. After the initial setup, the query execution plans looked great, but actual query time was just...

Thanks all for the replies. I would be using the partitioned view using tables on the same disk. I've read also that using separate filegroups on the same...

Alright, so I was being a bonehead and looking at users, not logins. I see exactly what you're saying about the properties showing whether it's windows auth vs. SQL...

Thanks Jeffrey,

Where at in the properties does it explicitly say SQL Auth vs. Windows Auth? I'm content knowing that the instance\user implies Windows Auth, I'd just like to get...

DavidB (2/9/2009)

---

Dr John Stott

"Nearly all legislation has grown up because we simply cannot be trusted to settle our disputes with justice and without self-interest. A promise is not enough; we...

Hi,

Thanks for that link! Going through that information I understand now why building/rebuilding the clustered index can have such a big impact. I don't believe my issue is...

Hi,

Thanks for that DBCC command. I just ran it successfully and reran the sp_spaceused SP and I see pretty much what I saw prior to running the DBCC command....

Thanks for those links Andrew. The first one is the info that I've been trying to go through.

It says that there are essentially three steps and I...

Have you tried using Profiler to get a picture of what's going on in the database?

I had similar timeouts previously and in my case, I was able to...

Ahh premature confidence...

I'm having difficulties setting the partner servers via "ALTER DATABASE [db] SET PARTNER =" command. Does the "GRANT CONNECT..." command impact the "ALTER DATABASE [db] SET PARTNER="...

Hi All,

I checked around my shop here and found that data is not being encrypted currently (or ever) using DbMKs so FORCE REGENERATE of the SMK would not pose a...

Thanks for the quick reply Andrew!

On your reply you say "CREATE MASTER KEY ENCRYPTION BY PASSWORD = ' ';"

When I run this on my DB to be mirrored, I get...