Somewhere in your code you are using the RAISERROR command and you are not supplying the correct parameters to the error string. 

RAISERROR ('The level for job_id:%d should be between...

It depends...

Index defrag and rebuild will have the same result.  Which one is faster depends on how fragmented the index is.

Reindex rebuilds the entire index from scratch, which can be...

Just remember that if you are testing two queries to see which one is faster, a good idea is to flush the server's data cache after the first query.  There is...

That will be the total size of your database, including any empty space.  It is possible for the transaction log or data file to have a lot of empty space...

Create a share on the mdb server for the folder the mdb is in.

Grant 'Everyone' read access on the folder, or preferably give the login that SQL is using use access...

Application role is something different to a SQL Roles.  You can use one of the following in your VB program:

- Create a single SQL Login and your VB program can...

Useful scripts above!!!

DBCC INDEXDEFRAG does not lock the indexes, but it does take a lot of CPU and potentially a lot of IO (depending on the side of your indexes)

DBCC...

I'm am not an expert in this, but I would expect that deleting a lot of data from your tables could cause excessive internal fragmentation, which is when space is available within...

To do this, you need to JOIN Table1 and Table2 like this:

UPDATE a

SET a.Status = b.Status

FROM Table2 a

JOIN Table1 b

ON a.[ID] = B.[ID]

I don't know of a way of joining tables...

3 seconds?  That is slow!  We have several tables over 1 million records, and if we offered 3 seconds to our users, they'd show us the door.  I have just...

The problem is that with EXEC or sp_executesql any variables you use in your select are created, used and destroyed in the scope of the EXEC.  Thus, when the EXEC...

To use Terminal Services the DBA needs to be a local administrator on the server.  He does not need domain admin rights.

You could use a trigger on the table.  The trigger will fire whenever an action takes place on the table.  If you really want to, you could see if the...

If you need to add a new extended sproc to your server, run sp_addextendedproc in the master database.

Examples

This example adds the xp_hello extended stored procedure.

USE masterEXEC sp_addextendedproc xp_hello, 'xp_hello.dll'

This is a shot in the dark, but have you checked for locks?  When the report is hanging, execute sp_who2 in query analyser.  See if your process is blocked by...