For routine work, neither Developers or DBAs actually need sysadmin rights to production databases. That is how mistakes happen that can be avoided. Developers shouldn't even have db_owner...

Hah! Looks like a Rookie used the Force on the Mighty Gila! 😉

I didn't forget, I just spent most of last night figuring out a problem I was having here at work. Hopefully tonight I may get some time to look...

steve_melchert (8/12/2009)

---

I'm not sure what jobs y'all have that allow writing these 1,000 word posts. I've spent more time on this board in the last couple of days than...

You can't restore a SQL Server 2008 backup to SQL Server 2005. If you need to move/deploy a database from SQL Server 2008 to SQL Server 2005, you need...

ChrisMoix (8/12/2009)

---

blandry said:

Last time we hired a DBA I was stunned at how many applicants had good SQL skills, but Zero .NET, Zero CLR skills. I know, I know, some...

Faiyaaz (8/12/2009)

---

Understandable, but what I mean is, like a notification popup when using the production db, a popup occurs warning you that you are on production. Why I ask, is...

Please read the second article in my signature block regarding asking for assistance on performance problems. Based on your post, there really isn't much we can do to help...

What is the fill factor on the table?

NewbieCoding (8/12/2009)

---

CREATE PROCEDURE [dbo].[p_getCallStats]

@Col1 int = null,

@col2 datetime = NULL,

@col3 int = NULL

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON

...

You will have to reinstall SQL Server 2005. There is no uninstall at this time for service packs. I think this may change in the future, possibly with...

Read about Recursive CTE's...

rja.carnegie (8/12/2009)

---

A previous exercise elsewhere, which I think was about testing for primes in the fewest characters of script, was where I learned you can use @ as a variable...

What did you find? Details please, someone else may have the same question.

Not really sure what you are asking here. Could you provide more information about what you are trying to accomplish?