Actually we are planing to do just that. My problem here was that I had already moved over all of the logins from my dev server during testing. ...

Don't get me wrong. The SQL code these guys are doing is fairly good. I'm not worried about it in that sense. I'm just looking for something...

Unfortunatly there are 2 very good reasons why our developers will never be sent to a sql server training class.

1) Several hundred developers

2) A VERY VERY cheep company

Not a good...

Unfortunatly it doesn't look like they have what I need.  I'm looking for something I can give my developers that will tell them whats new for them in 2005.  We...

I don't know abou tother people but I bought one of the MCTS SQL Server 2005 Implimentation and Maintenance Study Guides.  I'm not sure it really matters which one you...

You are looking under "Local Packages".  I belive it is talking about packages that are saved under the next 2 options.  "Meta Data Services Packages" and "Meta Data"

Kenneth Fisher

Just a guess but if the name of your SQL Server changed your pages probably have a DNS statement (or possibly multiple statements) somewhere that is pointing to the old...

Is it possible the creating program is keeping some type of hold on the file until you open it yourself?

Worked great

We ended up adding the DDL_Admin to the other role so we didn't have to add it to each user.  My understanding...

Can you post the code here?  These kinds of things are alot easier if you can actually look at the queries involved.

Thanks

Kenneth Fisher

I belive the closest you can come is this: On the general tab on the server propertys set the agent to restart when the OS starts.  Then on the advanced...

Not sure if this will help but recently I did a trace on object permissions.  Baiscally I logged any object where permissions were checked.  This should include all of the...

I'm not sure how much time it will take you but you could easily create a dynamic SQL script to do the work for you.

Create a cursor on the master.sys.databases...

Is some kind of clustering/load balancing configuration (adding in another server or 2) an option?

Ken

How are you getting the size of the tables?

Ken