You have to check on licensing. Active/Active needs one. "A passive server does not need a license if the number of processors in the passive server is equal to or...

I wonder if somebody answers.

The best that I can do is:

select

* from sys.database_permissions

where

grantee_principal_id =

(

select uid from sysusers where...

Rudy,

Did you mention that the covering index with wide columns will take a lot of extra space, will make inserts slower and introduce redundacy in storage? I thin we both agree...

You have to append a filter per line when using sp_trace commands anyway and use OR between the lines. Another suggestion, if you would like all tables but not system...

1. Check if users from the other domain that will not be accessible are logins in your SQL Server and owns anything including running jobs and DTS packages. Jobs and...

This is tricky.

I tried to run this line from the command line:

ECHO SOMESTRING \\MyComputer\MyShare\MyFolder\TEST.TXT

It works fine, a file TEST.TXT was created and records appended at the specified location on...

Hi,

The authentication mode is stored in the registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer

Value name: loginmode

If it is 1 then it is Windows Only, If it is 2 then it is mixed as...

John,

I agree it could be confusing. The answer: "It Depends" . You have to read BOL for each particular service. For example that you use, Reporting Services, read this in...

In every database in SQL Server 2000 there is a dbo.sysobjects table with UID column. DBO UID is 1, so whatever is not 1 is not owned by DBO.

In 2005...

I do it this way: in the filter set TextData Like %YourTableName%

For example this filter will trace queries towards sysusers table and will not trace towards sysjobs:

TextData Like %sysusers%

You have...

Lynda, Good Article.

Now, judging from my experience, I will advise ladies to work for IT. Similar to Kathi Kellenberger's dauther I was...

I think the best would be to change the table design and normalize this thing a little to put order numbers in one table and standard text in another message table?

sql_er,

do not do a huge delete! If you expect to delete all rows in a table, use Truncate Table, it is not a logged operation. If you expect to delete...

Hi,

It depends what DTS is doing. Some packages need to create or use files or other resources on the server. Let developers to try this package in the development environment,...

Alicia,

Indexed view is like a table, data are stored in the database as a clustered index and indexed views are not well suited for the data that are frequently updated. Do...