Chris,

Have you configured the security for the IUSER account???  It looks like a permissions thing currently.  I assume you are using IIS and I think you wil need to...

I think this is a collaboration between MS and Gallagher.

A cross between the TweakUI and the Smashomatic by Gallagher.  Watch me get the registry to accept a new value (People...

Sounds like a future QOD

IF defendant committed [INSERT Crime here] THEN which of following is correct:

1.  Defendant pleads innocent and gets probation

2.  Defendant confesses and x...

3.  Hung jury because SQLBill...

Xavier,

As fas as I know (and have been told) MS adds frequently accessed tables to memory, Master sp's and xp's to mem on start and database sp's etc... on...

Vik,

Did the backup for the T log also include a backup for the database?  If it did that could account for the drastic change in backup size.

Just something else...

xblondel,

I think that SQL will continue to grab more memory until it reaches the max you specify.  I have seen this with all MS products from Office 95 forward. ...

hmmm..  Didn't read this one closely enough...  Just curious though, The backup was set to ONLY do the T Log and didn't copy the database as well??

To add to what Frank has said please make sure that the WIDTH of the combined fields is <= 23.  If the length is greater the import will blow up...

Hi Eric,

I am pretty sure they will have to be unicode to handle the special characters. 

I have reviewed this since my last post where I think I was...

Just out of curiosity.  This application was approved by someone other than the IT department correct??

If no as the others suggested RUN.  Even if NO RUN. 

From day 1 the...

I chose Profiler for this reason:

1.  multi users complaining application froze AFTER update

2.  Nothing mentioned about still being LOCKED

3.  IF it happens again sp_lock will only catch snapshot

4.  DBCC INPUTBUFFER...

Rick,

Just move the corrupt LDF file to another directory or rename it.  The system will complain about the missing log file but will create a new one for you.

Almost...

I think that a lot of the 15GB might have been from the BULK-LOGGED which creates the largest T Logs (I think this was a QOD awhile ago).  After you...

I think if you create the table like below it might help

CREATE TABLE

(

[Field1] [VARCHAR] (255) NOT NULL COLLATE Greek_BIN

) ON [PRIMARY]

as an example (I think I did...

Something else to consider is the Collation of the database and/or the columns you are trying to insert into.  If the collation is not set to handle the characters the...