just my 2Ct

Rule no 1 in _any_ RDBMS : tell your system what you know ! If you know it's an integer, don't declare a decimal , if you know...

this should get you on track :

    'script de database

    Dim oDatabase As SQLDMO.Database2

    Set...

What kind of diskdefinitions do you have ?

san / nas / other ?

did you take a look at

- http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp

- http://www.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine_.asp

- http://www.sql-server-performance.com/clustering_2000.asp

my 2ct

- did you stop and restart sqlagent _after_ you enabled the (first) alert ?

- also add traceflag 3605 for more deadlockinfo in the sqlservereventlog.

- you could go for N(var)char solutions and avoid collation issues.

- if you're using a database per collation, _all_ interdb stuff has to perform collation translation to be compatible. Check...

great way to proove there is always more than one way to skin a kat

"...create table link (

    recno int identity not null,

    recno1 int not null,

    recno2 int not null,

    objectno varchar(255),

    :

    :

    :

    modified_date datetime null constraint [df_link_modified_date] default...

If they remain at the same path, there should be no issue if your sqlserver is at exactly the same version/sp/hf...

Just perform the rename-server procedure :

-- (http://www.databasejournal.com/scripts/article.php/1496451)

Create proc uspRenameServer...

If you've installed with the same drivemappings/locations, there should be no problems, if you move all db-files to these locations (as they were at the "old" server).

Otherwize, you may have...

Aha, a new network-rooster a the barn wanting to galvanize so (s)he is thé employee of the year !

1) Don't panic (I know...

- sqlserver needs some (?) time to check and correct it..

- Can you post an example script for a job where you encounter...

In that case, I hope this can help out

TEST_TEST_TEST

declare @ParentTbName sysname

declare @ParentTbOwner sysname

Select @ParentTbName = 'T_Server' -- = your table to be dropped

,...

Include dbo to Model-db so it is included in every new db that will be created.

Try this 

_test_test_test_...

-- jobi dd 19/03/2004

-- toevoegen YourDomain\YourDBOUser aan server en met db_owner-rechten op alle...

there is a web sql-management intereface (I beleive at MS) downloadable, I cannot rember where, but it had this functionality.

If I find it...

you mean dropping the parent table will also drop all dependant tables ?

sqlserver does not support that. You'll have to build your drop-ddl yourself.

You can do that with a recurrent...