Hi

Did you try the function I submitted?? damn site simpler! 🙂

This was a port from an old classic C function

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

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

Hi there

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

I have an Article I wrote sometime back on an example fix...

(Word Doc) SSPI Context Error Resolution Example

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

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

From google groups:

CREATE FUNCTION dbo.ConvertHexToInt (@inputstring varchar(20))

RETURNS int AS

BEGIN

DECLARE @digit as int;

DECLARE @result as int;

DECLARE @index as int;

DECLARE @length as int;

DECLARE @convstr as char(16);

SET @result...

Hi

"Sent it back to you", do you mean the full backup file or the physical database files?? how did you get the DB up and running again (sp_attach?) or...

Hi there

This is a really tricky one and hard to answer. I suppose the issues are compounded with these variables:

a) how the growth settings are configured for each...

On the 16th I believe.. some more senarios etc are discussed.

Chris Kempster

http://www.chriskempster.com

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

Hi there

Some things to check:

a) do a full backup, then run the stored proc to do one and only one log backup, try a restore by applying the full...

Hi Steve

Actually, I forgot to discuss archiving projects, even in part 2 of the article. How and when you clean up is up to you. One of the...

Hi there

Your problem is that you want to know what objects to grant the crystal user access to id image and avoid doing a code walkthough (by this other person)?...

Well im not writing it for you ... but check these objects out:

mydb..sysmembers: contains a row for each member of a database role

master..syslogins: hooks to...

Hi there

I dont know a lot about it, but may be able to help. We here use crystal reports, we use the RDC API and not the enterprise api...

Hi there

There are no virtual columns, such as rowid, that you can access "easily". The row is located via a file:page:slot combo, all of which is not quickly accessible...

shoot, sorry, my comment was for SQLBill - didnt read the posts carefully enough. Anyhow, SQLBill, with that honking great table, what did you do with it?? this sort...

Hi

The size is not an issues. I would think very carefully about:

a) number and sizes of indexes and where they will reside

b) plan to stripe this table...

Hi there

The differentiator, i think, is to do with connectiveness and persistence of the connectivity. In client server the connection is made and persists at all times for that...