Hi Jen

There are some issues to be aware of, mainly around the execution of xp_cmdshell in the master db and how you setup a proxy account for non sysadmins to...

Hi there

Well, this is a funny one, ive seen the same error hex code but a different message:

Microsoft OLE DB Provider for SQL Server (0x80040E14)

The text, ntext, and image data...

Consider - DBAction @ http://www.wingenious.com/dbaction/

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

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

Well lets step back a minute here and talk about IT Directors - if I had an IT director that sniffing around the databases (because they were once a DBA),...

Hi there

Shipping - to apply any full/diff or trn backup file will require users being kicked from the instance, so when do you apply the backup to the log shipped...

whao, are we talking "rollback segments" here in SQL Server, whoo hooo 🙂 the end of writers blocking readers using the read consistent model of oracle? this would be...

Hi there

the "connect by prior" or "tree walk" as I like to call it, has no direct equivalent in SQL Server, there are some interesting changes in yukon that may...

I gotta say, when I read peoples job titles I relly have to wonder what the heck is going on with IT these days, for example:

<so and so posts a...

create table cktest_fti (id int identity(1,1), col2 varchar(50))

insert into cktest_fti(col2) values ('2.3')

insert into cktest_fti(col2) values ('2.4')

select *

from cktest_fti

where contains(*,'"2.3"')

==> finds the row

select *

from cktest_fti

where contains(*,'2"."3')

==> ignored words error

Sorry, my 1st...

whoops.. I ment this:

where contains(indexedcolumn,"3'.'0")

sorry about that.. cant read my own friggen scripts! 🙂

Chris Kempster

http://www.chriskempster.com

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

Hi there

Consider:

a) replacing . with "." before applying the search

b) try removing . from the noise work for the language breaker being used

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL...

Ok guys, im completely W R O N G, see messages below. Ill never use cognos again to suffice all my testing...

Via EM you get "error 927: database xyz...

Hi guys

well damn, now you guys have me worried, Ill run some more tests on it, at present I only have 2 users accessing the DB during my log restores,...

Hi there

Sure can, the DB is in "standby" mode, with read-only access. I have an article coming soon with a custom solution for remote servers (requiring no linked servers)....

Hi Frank

You mean this:

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1464

I downloaded the ebook the other day, have yet to read it but bits I did seemed fine. Like all things, its easy to pickup...