You don't want to do this often, for reasons George mentioned. However if you do shrink data flies, leave enough space to run a reindex on the database.

If you have...

OK, if I understand this.

You have a master SQL Server instance, let's call it Server A. This has various databases on it. You have a developer (DevA, DevB) and each...

Jim,

It's still not clear. You're saying you have developers and each has their own server? Do you mean that the developers have their own instance locally on their machines? And...

Immaculate correct....I like that.

Don't see an open event, but there is an event that snags object access:

http://msdn.microsoft.com/en-us/library/ms175013%28v=SQL.100%29.aspx

Are you connecting with SSMS? Try changing the default connections options when you connect to use TCPIP

Lynn,

I'd present on what people ask you questions about on a regular basis, or what problems you are constantly solving. That's a good place to start. It teaches, and it...

One more tip: document what you teach, and have people let you know if they use something. This would be important for continuing funding, or further training.

Perhaps you want to lay out more of what you are doing. If there is an unknown number of columns, how do you apply the logic to update them and...

GilaMonster (5/6/2010)

---

Grant Fritchey (5/6/2010)

---

Hmmm... They never even asked me how many questions I answered. I think if you took away the number of times I said "do you have an...

I think you might want to do this instead:

DROP TABLE dbo.mytable

go

CREATE TABLE mytable( col1 int, colb varchar(20))

GO

INSERT MyTable SELECT 1, 'a'

INSERT dbo.mytable SELECT 2, 'b'

GO

DECLARE @tbl TABLE ( cola int,...

I'm with Gail, start using 2008. What I might do is install the eval/dev editions and then rewrite some of your existing stuff in 2008, using new features. Take advantage...

This is the closest I've seen.

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c856b93-369f-4c6f-9357-c35384179543&displaylang=en

You ought to develop a process here to move the data regularly if this is history. A bcp out/in wouldn't take days.

Can you break up the transaction? There are times when you can "manually" handle the transaction. Break it up into chunks, and then undo it if one of the chunks...