Hi Steve

I cant see this happening really. I not a mathmatician or a statistician, but I cant see the real benefits for this sort of technology. There are...

Mark is right on the button! im stuck in my old v7 ways 🙂

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Hi

your mean something like this below, where @p_dbname is a parameter to the stored proc.

set @Nsqlstring = '

select @vfileid = fileid,

@vtotalpages = size - 1

from ' + @p_dbname + '..sysfiles

where...

Hi there

What approach did you take with the upgrade?

Is this error your application table related, or system?

Any fundamental architecture/OS changes? (long shot)

The error is fair enough,...

Hi there

See script below, then alter db and set to dbo only, of course, your users dont have dbo privs right? 🙂 see BOL for the syntax. I...

Hi there

Your example works fine for me.

Can you post your instance version info? have a look through MSDN as well. Ive tried wrappering around different combos of begin end,...

Hi there

I have the same issue, but with lots of space and a small DB (5Gb) its not an issue. I was contemplating switching the recovery model, if you...

Hi

What do you have?? backup? bunch of CSV files of some sort? from another DBMS (what format) we need a lot more info.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server...

Hi Brian

Good point actually, Oracle iFS (probably renamed) is an interesting piece of technology, especially the customisable render routines when sucking files in a out of the iFS repository. ...

Hi Guys

Yep, got this a few times, but I have to say that the searching is very poor and at times, I struggle to get what I am after, even...

Hi Steve

I think, with all of your "Today" comments, is Microsoft should take a long hard look at the environment around them, namely Oracle, DB2, CACHE, and other databases. ...

Hi there

The advent of OO databases has been a bit of a shammozel really, and to some degree the main architects (Microsoft, IBM, Oracle) have been guilty of not persuing...

Hi there

http://www.chriskempster.com/tipsandhints.html

Run the server network utility GUI, select the appropriate instance. Highlight then enabled protocol (TCP/IP) and hit the properties button, for the default port enter your port numbers seperated...

Hi Randy

So whats the combo of commands to "get a text based execution plan after the execution of the statement", as showplan_all and showplan_text dont physical execute the parsed statement...

Hi there, as per the doco, note the begin trans:

SET XACT_ABORT ON

GO

BEGIN TRAN

INSERT INTO t2 VALUES (4)

INSERT INTO t2 VALUES (5) /* Foreign key error */

INSERT INTO t2 VALUES (6)

COMMIT...