We know the Host Name (computer name) from sysprocesses. I wonder could we use WMI class Win32_LoggedOnUser to get this info. The problem is that the person running a...

Hello,

You MUST be logged to BOTH computers as a Domain User that is a valid user in BOTH domains, check what trusts were established, one or two way trusts, this...

I just ran Profiler while opening Show Dependancies on MyTable with 2 fields in the Design View in Enterprise Manager. It executed the statement for each of 2 fields:

exec sp_MSdependencies...

Sa24,

The article I mentioned says "both size and number of IOs"  And it have graphs. Anyway, if the drive is 75 % full it will be filled in completely fast.

Reletaed...

Should we be learning DMO or SMO now? SMO (SQL Server Management Objects ) are a superset of DMO and extends a DMO model. We can use it with SQL...

Antares, thanks.

I like your opinion too and the concept of Competing Data Products.

I went to the Microsoft seminar "Unlocking BI Power in SQL Server!" today delivered by...

John, thanks! Those are good points.

I need to clarify why I am asking those questions. Somehow the executive reporting (oh, I like this term) as well as other types...

Your system administrator probably referred to performance degradation as explained in Fred Williams reply above. You may also read Microsoft SQL Server 2000 Administrator's Companion Part 2 Chapter 6 Topic...

Here is a solution recomended several years ago by Microsoft, I don't know if they still recommend it. I have one application created this way (not by me)

Put all tables in...

Do you know anything else about the database structure and activity?

Is Tempdb really used much? Is there a lot of memory on the server? Are there big tables? Are there...

Hi, I have a couple of SQL Server 7.0 SP4 on NT4 Servers. Our Domain Controllers were Windows 2000 for a couple of years and now they are Windows 2003....

Look, Briscoe, BOL says:

"...can initiate automatic failover if the principal server instance fails..."

It is failover, not failure. But, you are right. Too much "Law and Order" for Microsoft developers. Even...

What was the error message? Sure, there should be a password for a login, but it could be also many other reasons for the script not to run.

Uncheck "Show Friendly...

Hi,

Did someone tried SQL Server Reporting Services? How much do they show? Amira may be able to use a commercial report tools in order not to use a front end...

Hi,

Is your application inserting/deleting data by recordsets? some transactions are implicit. There may be no open transaction when you were looking at the log, but for example, just before and...