maybe stupid, but did someone use any form of compression ? (drive/LUN level)

of course that also depends on what your udf is doing !

is it just a split/string function or does it perform access to other objects ?

if you post it we...

Actually the install of sql2000 shouldn't cause a technical problem.

Who detached your database ?

Where has it gone to ?

Did someone just uninstall the sql2005 engine ?

and off course there is a difference in Red Cross junior camp first aid, Paramedic first aid and combat first aid 😀

According to their trained skills, you may have a...

Well ... your indexes also need space !

So depending on the size of the columns you used in the index ddl, they will be smaller or larger combined with the...

Outrageous for any software to be implemented in that way !

Complain to your manager that this simply is not acceptable !

Have him complain with the software vendor and make it...

ldave (4/2/2009)

I have created a view with code that looks like below.

use testprd;

SET NUMERIC_ROUNDABORT OFF;

SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,

QUOTED_IDENTIFIER, ANSI_NULLS ON;

create view test wtih schemabinding as...

I think "discovery"' doesn't function on 64-bit environments.

You should be able to just enter the sqlserver name (server\instance) and connect with ssms !

If that doesn't work...

Did you enable the SQL...

Your trigger tries to execute sprocs in the [Changes] database !

Does that database exist on the sql instance ?

OR

Does the user executing the update have the needed...

Nice approach list :w00t:

The "Remain Calm / Keep your head cool / Keep on breathing" should actually be put after every major point.

In case of urgency, that is vital...

It depends !

With an upgraded database, the default schema will be the userid.

This script needs to be executed with sysadmin auth because of the "execute as" and "Revert".

Don't forget to...

As Greg stated, it is an add on component after your sqlserver has been installed.

You can download it from Feature Pack for Microsoft SQL Server 2005 at http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

The component you...

Since partitioning is an advanced topic, it is highly recommendable to read BOL and to read the white paper on partitioning.

(make sure you have the latest version of BOL !)

-SQL2005...

Is you database case sensitive ?

If you enter a default schema for a user, it will nolonger search the way it did in sql2000 !

AFAIK you only need to install the backward components if you want to be able to modify the packages.

Keep in mind to put your DRP for this upgraded server in...