SQL Server Express

RE: billsalkin

• by Allen-Cui-55137

• SQLTeam.com

• Reply

OBJECTPROPERTY ( object_id(tablename), 'IsAnsiNullsOn') DATABASEPROPERTYEX( youedatabase , 'IsAnsiPaddingEnabled' ) DBCC USEROPTIONS

2003-06-05

RE: Effecient decimal precision and storage

• by Frank Kalis

• Database Journal

• Reply

Hi BillyWilly, quote: However, My current system runs like the wind and can calculate and serve formatted HTML for 20 funds, 9 time series(Daily, Week To date, Month to date...), for a five year period in under a second - no problems there. have you ever considered a marketing or sales job So what are […]

2003-06-05

1 reads

RE: Disaster Recovery [?]

• by SQLBill

• SQLTeam.com

• Reply

I don't believe you can get the data back. Transaction log backups (and differential backups) must be applied to the FULL BACKUP made prior to them. Had someone made a FULL BACKUP when the database was set up, then you could restore that backup and then the transaction log. Sorry, I guess this is where […]

2003-06-02

RE: How to keep and restore the deleted records?

• by scraft

• Database Journal

• Reply

I have had very good success adding these columns to all my tables (all with simple indexes) cUserIns Char(24) tDtIns DateTime cUserUpd Char(24) tDtUps DateTime cUserDel Char(24) tDtDel DateTime iDel Int default value for iDel is 0, default value for tDtIns is getdate(). When any user does a delete, put a 1 in iDel and […]

2003-06-02

1 reads

RE: Find out Access Table Names via DTS

• by Allen-Cui-55137

• Database Journal

• Reply

Which authentication method Did you register your SQL Server in EM? Try login QA with SQL Server Authentication.

2003-05-29

RE: Is Steve Jones Really Steve Jones?

• by Steve Jones

• Database Journal

• Reply

Or not as funny to others as to you and my wife. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net

2003-05-28

RE: slow performance,can it be done faster?

• by jpipes

• Database Journal

• Reply

Wow. Where do we start. 1) Don't use cursors. This procedure can be rewritten using standard SET-based SQL commands. First, do the update on current date records where they match on the correct criteria (sequence number). Then do the insert for the records which do not match. Then do an update for the 7 days […]

2003-05-22

1 reads

RE: SQL Server stops listening

• by Crispin

• SQLServerCentral.com

• Reply

Sounds like there's wax in the network card. Take an ear bud and give it a clean. Sorry, a VERY lame attempt at humour. It's late Cheers, Crispin

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-22

1 reads

RE: NT Groups and SQL Server Access Right

• by JMac-1

• Database Journal

• Reply

Thanks for your help bkelley. The exact error that I have when a member of the group try to connect is: “Unable to Connect to server xxx Server: Msg 18456, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘Domain\Name’” Do you have put in place the same structure than me: Domain […]

2003-05-21

1 reads

RE: date problem with SQL 2000

• by Gareth-Ablett

• SQLServerCentral

• Reply

quote: quote: Have you checked Regional Options on the server. I seem to remember having this problem before and always struggled with it. I have my servers set to British the date formatted to dd/mm/yyyy and dd mmm yyyy. I do what mlwang does and use yyyy-mm-dd format for input and matching. I know that […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-20