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...

The only way I can think of doing it would be to save the DTS package rather than use the "Run Immediately" option.  You could then edit the CREATE TABLE...

CREATE TABLE #TableSize(

 TableName SysName,

 NumOfRows Int ,

 Reserved VARCHAR(10),

 Data VARCHAR(10),

 IndexSize VARCHAR(10),

 Unused VARCHAR(10)

)

DECLARE @sNextTable SysName

SET @sNextTable=''

WHILE @sNextTable IS NOT NULL

 BEGIN

  SELECT @sNextTable = MIN(Name)

  FROM dbo.SysObjects

  WHERE Type='U'

  AND Name > @sNextTable

  IF @sNextTable IS NOT NULL

   INSERT...

Are the apps all accessed via a browser?  Could you put a block on all access attempts that don't originate from the web server or IT computers?

If the apps connect via...

Provided your index statistics are up-to-date and you have a primary key and/or clustered index on your table then the following query is the quickest way of getting a row...

Check the table and indexes.

If you don't use double-byte characters then replace an NVARCHAR, NCHAR, NTEXT columns with VARCHAR, CHAR, TEXT equivalents.

If you have these columns then not only will...

SELECT *

FROM t

WHERE CONVERT(CHAR(6),t.testdate,112) < CONVERT(CHAR(6),getdate(),112)