SQL Server Express

RE: HResult of 0x80040e37

• by Site Owners

• SQLServerCentral.com

• Reply

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-07-24

RE: Backup Plans

• by BigG

• SQLServerCentral.com

• Reply

Thanks a lot for that. Graeme

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-07-23

RE: UDF as Computed Column Part 2

• by noggin

• Database Journal

• Reply

Pardon my ignorance but what is BOL?

2003-07-15

RE: Question of 7/3/03

• by cneuhold

• Database Journal

• Reply

The one about usr and pwd was just "best practice" advice -> code clarity and readability. regards, chris.

2003-07-07

RE: Workaround needed to run sp_addlogin

• by Steve Jones

• Database Journal

• Reply

Personally, I'd abstract it. Set up a table and have the Access front end insert users into this. Then have a stored procedure the reads this table (top 1) and runs sp_addlogin to create the login. then marks or deletes the entry and repeats. You could schedule this to run every minute or run it […]

2003-07-02

RE: Locking problem

• by Johan Bijnens

• Database Journal

• Reply

"It actually is like this: Begin Tran, Insert into Table1 (on connection1), Select max() from table1 (on connection1) then insert into table2 (on connection2)." Because your Insert is still uncommitted, it is not the max-function (cursor or not) that holds your locks (it can give you a reliable result because it with the same connection, […]

2003-07-02

RE: Slow Distinct Query

• by tulcanla

• Database Journal

• Reply

is member_id a primary key or a part of the primary key? From may exp. when I call the primary keys in the select statement, SQL engine uses the index fully; Try not use distinct, but group by;makes it faster regards lmt

2003-06-30

2 reads

RE: Group Policy for MMC

• by gbn

• SQLServerCentral.com

• Reply

I've already tried that, looking at the domain level and at the local policy using my PC. Thanks anyway.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-30

2 reads

RE: Directly importing data from an email

• by Frank Kalis

• Database Journal

• Reply

Hi roadrunner, quote: Is there a way to import data directly from an MS Outlook email into a SQL2000 table without exporting the data to a text file first? several ways to do this without flatfiles. i guess most easy is using the Exchange ODBC? Driver from M$, but I don't know if it's still […]

2003-06-27

RE: SQL Server Agent fails to start - no error msg

• by mezocs

• SQLServerCentral

• Reply

Hi Frank, It was nice that you tried to help. Here are some further answers: - 0 connection limit I also don't understand exactly but I think it means no limit. I also found it on the Internet and it seems to be ok. - the 'DBMSSHRN.DLL' is used by SQL Server for shared memory […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-20

1 reads