Is there any looping / cursors done in the sproc......

Attaching a MDF will only work if you previously detached the database first.

( then the database will be in a consistent state ) only then you can attach the...

I Really wonder when i could use this.

Would a indexed UDF really be faster than a join.....

( I tested it and it isn't )

Furthermore is a UDF the right way...

select * from tblNews_Items where division = coalesce(@Var1,division)

I am not really sure but are you using a Linked/remote server here......

If so make sure the codepages are the same and make sure you set this correct in the...

Well Simple......

I would not look in SQL server for a start. But in the page.

To see if the sluggishness of the system is really caused by IIS. Try IISRESET.

Thie will...

Try performance monitor.

Have a look at Physical disk.....

Disk QUE length.....

Don't forget DIskperf -Y.....

Sorry for beeing late at this.....

The problem is i get something like :

create default [defstatus] as '00 '

And I Really want the Value '00 '

Because what if a...

I had a similar experience once with a unique index.

After lots of digging we found out that de clustered index was broken. ( The clustered index was on that field).

DBCC...

I really don't know if it is possible....

but if it is a read only query try Set transaction level read uncommited....

Won't solve the paralel query problem but will probaly solve...

Simply not create a temp table but a real table with text fields..... Shouldn't give a problem.

Simply add an extra field to recognize your own records in it...... so you...

or call OSQL in VB.....simply write the sproc to disk somewhere and start OSQL with the filename as parameter.... (See osql -?)

en then simply let OSQL execute your script......

should be...

You will need the tables to bes cripted as well......

Here is the script.....

create procedure dbo.dmoScriptTables

@pDatabaseName varchar(255),

@workingfolder varchar(255) = null,

@pInstanceName varchar(30) = null

as

/**********************************************************************************

Script...

Well it is not completely mine but here is a nice sproc that will script everything in a DB to a file......

CREATE procedure dbo.dmoScriptDatabase

...

Hendra YOU ARE A KING !

thanks A LOT !!!!!!