If I have a regular import job then I use DTS.

If I need to do a quick one off then I tend to do my data cleaning and preparation in...

Can you give an example?

I tend to design my tables with rules and defaults so I am not sure why you need a trigger to enforce this?

Pause a moment whilst I swear profusely

I wish I had known about fn_replinttobitstring & fn_replbitstringtoint, it would have made my life so much...

Andy,

Sorry to add to your woes but I also get the (1 item remaining) message on the shwmessage screen, although everything appears to work correctly. 

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=93623

If I click the...

No Andy, but then under Mozilla the reply form is just bog standard HTML rather than the ActiveX control you see under IE.

Under IE I can see all the toolbars...

I would also recommend putting some sort of logging code into your front end app.

When I have my code in a DLL then every function has an error trapping clause...

Have you noticed that when you write an ActiveX DLL, passing values ByRef is faster than ByVal, but when you write an ActiveX EXE the opposite is true?

Just as an aside, every year in Britain we have the New Years honors list where persons who have made a great contribution to British life get enobled with awards...

Frank,

The $HTTP_REFERER, $HTTP_POST_VARS and $HTTP_GET_VARS stuff is dictated by the PHP.INI file. I'll find out which setting it is that determines thebehaviour and pass it on when I return...

I appreciate your problems with a couple of hundred databases, but the thought of trusting the backup of that lot to one maintenance plan gives me the screaming heebie jeebies.

One...

My brother in-law described PHP to me as "imagine if all the frustrated ASP programmers got together and said 'I wish ASP did this', then they got drunk and added...

I suppose the aim is to have a quality mark against the posts on the forum.

The stars do not affect the validity of the answers given.

At present you have a...

You could have coded your SP as follows

CREATE PROCEDURE usp_check_login

  @username varchar(20),

  @password varchar(20) AS

  SET NOCOUNT ON

  SELECT user_id,

    user_active as login_active,

    user_loginattempts as login_attempts,

    user_type

  FROM tbl_user

  WHERE user_username = @usernameAND user_password = @password

  RETURN @@ROWCOUNT

GO

That...

TRUNCATE also fails if you use foreign key constraints, regardless of whether they are violated.

I fully agree that people should not be allowed to create datbases willy-nilly.

If developers go creating...

Firstly, I've come across SQL6.5 a couple of times recently because it was a huge undocumented, mission critical application written in C++ where the source code had been lost. ...