If you use a user defined function in this way then I believe that SQL will use an implicit cursor because the function has to work on a row by...

Try http://spambayes.sourceforge.net/windows.html

You have to install Python on your PC but it is easy enough to install.

Make a folder in outlook and store all your spam in it until you have...

You can happily fire off stored procedures from within stored procedures.

Let us suppose you have a return value. You could include syntax as follows

DECLARE @lResult Int

exec @lResult=usp_myproc

If you...

Pretty unanimous opinion here Steve. I'm afraid you are just going to have to keep writing those editorials!

Using the Outlook 2003 blocked senders facility I blocked 113 SPAMS this morning.

Every morning I add between 20 and 30 new addresses to the list.

Theoretically I should trawl through the...

And of course having a son who can jump start a car without tools is always a blessing!

I wonder if they are still looking for extras in the next X-men...

During the first year your hi-fi and personal possessions are safe. 

You put the baby down it stays put.

After that they follow you EVERYWHERE and get into EVERYTHING. 

Blackcurrant juice...

There are two ways to do this.

1. Use either a TEXT or NTEXT field.

2. Compress your string in some way

Personally, I would go with option 1.

Option 2 is messy and...

Access is famous for causing locking problems with SQL Server.

Try creating a views for each of your SQL Server tables as

SELECT [field1]....[fieldn]

FROM dbo.YourTable WITH NOLOCK

Then try connecting these to your...

The easiest way is to use Enterprise Manager.

right-click on TempDB and adjust the size under the Data Files and transaction log tabs.

For production databases you should have set the option to block updates on system tables

exec sp_configure 'Allow updates',0

RECONFIGURE WITH OVERRIDE

I have an old PIII 450MHz lap top and don't get the problem no matter how many windows I have open.

Mind you I do tend to use Firefox rather than...

TEMPDB is a special case that is used for a variety of cases so you don't need any specific permissions.  You will notice that there is a guest user in...

If your first few steps only take a few seconds then I would use temporary tables or table variables and have a stored procedure return the records you want in...

Not as the script stands.

sp_spaceused has an @updateusage parameter and to use that you either need to be the dbo or in the sysadmin role.

I've not used it here so...