For a column that is not physical, which is a computed column, a foreign key constraint cannot be created. Here is a test case:

Create Table Foo

(FooPkvarchar(255) not null

, primary key...

Is the SQL Server Clustered and behind a FireWall ? A firewall may be in effect is a Virtual Private Network is being used for connectivity.

SYMPTOMS

If you try to...

It appears that only the /3GB is being used. Check the SQL Server errorlog for a message "Address Windowing Extension enabled". If missing, then AWE is not enabled.

Confirm that...

From your example:

IF (@@ERROR> 0)

BEGIN

INSERT INTO ErrorLog (Table, Error) VALUES ('Table2', @@ERROR)

ROLLBACK TRANSACTION

END

As there is a rollback, this will also rollback the insert into...

"When the SQL machine calls the Win32 Process on the Cognos machine through Enterprise Manager/DTS, where is the process attempting to execute?"

The process is running on the SQL Server -...

For SQL Server 2000, use this SQL

selectcast( serverproperty ('machinename') as nvarchar(128) )as MachineName

, cast( serverproperty (IsClustered) as nvarchar(1) )as ClusteredInd

Where:

MachineName values are:

For a cluster, the virtual SQL Server Name

For a...

"disabling or deleting in AD didn't update the syslogins"

That is correct as the SQL only reports what login SIDs are no longer in Active Directory and what logins have had...

Were you aware that the optimization process for a table and its associated indexes makes a complete new copy ?

The total amount of free space needs to be based whatever...

To determine SQL Server Windows logins that no longer exist in Active Directory ( or on the local server for local accounts), run this SQL:

select *

from

(select syslogins.nameas ...

Although exporting/importing registry did work at one time, this method no longer works. The good news is that Gustavo Merle has written a VBS to perform this function.

http://www.sqlservercentral.com/forums/printtopic.aspx?forumid=24&messageid=270935

C:\WINNT\system32>rexec.exe /?

Runs commands on remote hosts running the REXEC service. Rexec

authenticates the user name on the remote host before executing the specified command.

REXEC host [-l username] [-n] command

host...

Check the event log on the linked to server for these errors as:

1. Timeouts on connecting to Active Directory

2. Changes to Active Directory Group Policy

There is a bug in Task Manager (http://support.microsoft.com/kb/269551) that applies to Windows 2000 and 2003, where the amount of memory used by a process is not correctly reported in all...

"how would I find out what mode it's in?"

In SQL Query Analyzer, run this SQL:

select DATABASEPROPERTYEX( databasename , 'Status') as DBStatus

, DATABASEPROPERTYEX( databasename , 'Recovery') as DBRecoveryMode

go

For DBStatus, the possible...

This can be caused by Active Directory changes under the following sequence of events

1. In AD, create a group named DBAs

2. In AD, add account "domain\Carl.Federl" as a...