Viewing 15 posts - 16 through 30 (of 122 total)
Is there any looping / cursors done in the sproc......
July 2, 2003 at 3:59 am
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...
June 30, 2003 at 3:44 am
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...
June 19, 2003 at 6:01 am
select * from tblNews_Items where division = coalesce(@Var1,division)
May 21, 2003 at 2:26 am
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...
May 19, 2003 at 2:17 am
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...
May 14, 2003 at 4:56 am
Try performance monitor.
Have a look at Physical disk.....
Disk QUE length.....
Don't forget DIskperf -Y.....
May 14, 2003 at 4:46 am
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...
May 13, 2003 at 4:08 am
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...
May 13, 2003 at 2:16 am
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...
May 12, 2003 at 9:36 am
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...
May 12, 2003 at 9:31 am
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...
May 12, 2003 at 9:25 am
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...
March 28, 2003 at 2:54 am
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
...
March 28, 2003 at 2:53 am
Viewing 15 posts - 16 through 30 (of 122 total)