I have verified the behavior with SQL Server 2005 SP4.

I also...

roger.plowman (9/9/2011)

---

This thread is just another version of "should we promote certificates". 🙂

Having spent 30+ years in the industry as a jack-of-all-trades (master of none I admit) I've seen great...

I have a degree, but in Physical Education. I got into development and databases because my best friend at the time was the software development manager at a local...

Brandie Tarvin (9/8/2011)

---

Jack Corbett (9/8/2011)

---

You don't have a package configuration somewhere that is overwriting the design-time value do you? It sounds like that could be it since having a...

You don't have a package configuration somewhere that is overwriting the design-time value do you? It sounds like that could be it since having a different name makes it...

I can only suggest running a trace when running the GUI for both tasks as they must be doing something differently when getting the data. I don't have the...

I've missed 24HoP due to work not liking streaming (I really need a telecommute job) and other responsibilities last night.

I believe I'll be seeing Grant on Monday night....

Sounds like you have multiple files in tempdb. What's the result of this query:

USE tempdb ;

GO

SELECT

*

FROM

sys.database_files AS DF

Duplicate post. Please post answers here

Check out this post by Devin Knight.

You can determine what FK's do not have an index on the column with a query like this:

SELECT

OBJECT_NAME(IC.object_id, DB_ID()) AS table_name,

...

Try checking for server triggers.

USE MASTER;

Go

SELECT * FROM sys.server_triggers AS ST

SELECT * FROM sys.triggers AS T

The error clearly says that there is a trigger involved that is not allowing dropping...

You should be getting a "Save As" file dialog box that pops up. My guess is that this is coming up in the background. Try minimizing and then returning...

I'd check fill-factor on the indexes, particularly those that show high fragmentation on a regular basis.

Also what are the clustered indexes set-up on? Are they on monotonic columns...

Duplicate post. Please post answers here