I'm not sure that you will be able to script this out (as you cannot see what users' passwords are).

I would ensure that users are specifying complex passwords by ticking...

When you run your package in SSDT, are you using Windows Authentication?

I'm guessing you have access to the FTP site and that's why it is working.

When you run in the...

From this article http://support2.microsoft.com/kb/2681562 it says that SQL 2005 is not compatible with Windows Server 2012. This could be the reason why you are having problems.

I know it's not a...

How are you rebuilding the indexes?

Say for an index with 2 pages, if the rebuild does not put those two pages next to each other (for whatever reason) you'll end...

Hi,

1. Yes you can grant select to tables and deny to views in the same schema. The way I would do it is to add the user to the db_datareader...

When you are running the following:-

ALTER TABLE [dbo].[DTb_HWSQueueMonthEnd] DROP CONSTRAINT PK_DTb_HWSQueueMonthEnd

ALTER TABLE [dbo].[DTb_HWSQueueMonthEnd] Alter Column [Patient System Number] varchar(10)

ALTER TABLE [dbo].[DTb_HWSQueueMonthEnd] ADD CONSTRAINT PK_DTb_HWSQueueMonthEnd PRIMARY KEY NONCLUSTERED ([Patient System Number]...

I take it the PK on the table also has a clustered index?

Just want to check, are you running this on your local instance, off a local drive?

I've seen jobs that check the SQL log for errors causing issues as they lock the files and prevent the cycle from happening.

In order to solve this I move the...

I've been in similar situations and it's frustrating as hell.

The only thing I can say is back what you're advising with stats. If you see a poor performing query, show...

bugg (9/29/2014)

---

Hi, actually there is one index on the table, solely on custid.

Yes, I can change the frontend app code to add the last_modify_date and remove the trigger from table.

I...

From my first impression of looking at the deadlocks, the trigger does seem to be causing the issue.

You mentioned that you have no indexes on the table, do you have...

We're running a Dell Compellent, with two SC8000 controllers (16GB of cache) and two SC220 enclosures each with 14 x 15k disk (one hot spare per enclosure).

It's a very simple...

No schemas are database level objects.

http://msdn.microsoft.com/en-us/library/dd207005.aspx

Jerry Inman (9/26/2014)

---

Are you referring to the SQLsafe backup agent, running on the client? It does seem to leak a little, over time, but mine usually stay between 150 and...