Or if you know that this table is updated only by your application, you can put this logic on the application level.

Hi,

there is a file TNS Names in Oracle client that has to have entries. My Oracle user did it on my computer for her database.

I would ask an Oracle DBA...

Steve and John are correct. It may be just a typo in the path that you provided for the query. If there is no path name in the error log...

Hi,

I normally ask for 4 GB RAM for SQL Server. I don't usually enable AWE (it is a good idea too to enable it for more then 2 GB) so...

I always get this message when I am upgrading (or test-upgrading) the database application when I have Enterprise Manager open and the upgrade script is running. That is why each...

Hi,

Right-click on the shared folder on the server and go to 1.Security Tab - Click Add and follow the screens. 2. Sharing Tab - make sure Shared As is clicked...

Agree with Brian.

I did want to add myself that the backups are very readable in the text editor but was afraid to sound too pessimistic.

Rudy,

--- 4) revoke sysadmin from all Windows Users/Groups except 'Builtin\Administrators'

Them, AD Administrators like to group into their own group and use scripts to add this group to local Administrators group, which...

I could not find it too. The only polling interval in 2005 BOL is applicable to Target servers when you have Multiserver Administration

Moreover, there is no Edit context menu...

Hello,

The default share permission is READ for everyone, so your DIR command will execute, but you need CHANGE share permission and WRITE NTFS permission on the share \\WebServerName\EdIdata...

Natalie,

here is an example of the job that deletes old backups.

The job step has to be of ActiveX  Script type. In the Command textbox enter something like this replacing MyBackupFolder...

Hello Mathew,

I usually run

DBCC FREEPROCCACHE

after updating statistics or in your case after creating statistics. SQL Server uses statistics during creating execution plans when compiling. DBCC FREEPROCCACHE will...

When you say "There is a Windows group", what is the scope of this group? What is a domain functional level for Domain Y? Could it be that it is...

Great Question!

Here is a good article on how to use Network Service account in ASP.NET and SQL Server:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/paght000015.asp

How To: Use the Network Service Account to Access...

I tested it, it works! Good Job David!

They say in Russia that " NEW is a well forgotten OLD "