No, the tables don't have to be linked.

The easiest way to think of triggers is as a specialized stored procedure. It is called automatically by SQL Server when the operation...

You are running Query Anaylzer from a client, yes? In other words, your workstation and not directly on the test server?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

When any literal string is preceded by a N, it tells SQL Server to make it an nchar/nvarchar/ntext (Unicode) string.

For instance:

SET @String = 'Is NOT a Unicode string'

SET @String =...

I see the knowledge base article only lists SQL Server 6.0 and 6.5. However, we were having problems on a 7.0 server. As soon as we switched to copy, everything...

If your windows account was explicitly given rights to login in to SQL Server (not through the BUILTIN\Administrators group) and had sysadmin server role rights, a quick fix is to...

It stores it in the job step itself. For example:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 40513CD1-A02E-4806-B866-5B67895C747A -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP" -DelBkUps 4WEEKS -CrBkSubDir -BkExt "BAK"'

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Reading over the paper, it does look like SQL is using a hash (SHA). The problem is SQL Server records two hashes... one which is upper cased. As a result,...

Looking at the particular statistics, this is an extremely small table, is it not?

You've got 3 extents. You had 2 extent switches. This is the minimum number. An extent...

If you take a look at the SQL Server:Cache Manager object in Performance Monitor, you'll see Counters for Cache Object Counts and Cache Pages. By watching the values of the...

Can you post the dump information? Should be in your SQL Server logfile. That may help us track down a Q article which corresponds to the problem you are seeing.

K....

Unfortunately, you're going to have to go several places to get this information.

The basic information on the maintenance plans are stored in the following tables of the msdb database:

• sysdbmaintplan_databases
• sysdbmaintplan_history
• sysdbmaintplan_jobs
• sysdbmaintplans

These tables...

The advantage xcopy had over copy in the DOS days was copy copies one file at a time... regardless of how large they are. The xcopy command was a bit...

Was the client connecting via Named Pipes or TCP/IP as the default library? If the client and the server are not one and the same box, often TCP/IP is faster...

How about (I'm using @catID to represent the parameter... here's the basic SQL query):

SELECT 

    R.*

FROM Recipe R

  JOIN RecpCat RC

 ...

The problem is that you are executing a dynamic SQL statement. That runs in a separate context than the process that calls the EXEC in the first place. The variable...