Hello,

Do Actions ->Refresh.

Sometimes it does not help too with logins and users. Then I disconnect in Enterprise manager and re-connect. This is a matter of refreshing information for Enterprise Manager,...

I had this issue in 7.0 for one of my databases. Log could not be truncated and shrinked no matter what. I think it was sort of the bug in...

I had to add something into tnsnames file on SQL Server machine. Ask your Oracle administrator

Brent,

If I got it correctly, Recovery Model is Simple which means that log is truncated on checkpoint, you have a lot if disk space and automatically grow file is checked.

I would...

What is on the Transaction Log tab of the database properties? Is "Automatically Grow File" checked or unchecked? If it is checked then the log will grow automatically if you...

I normally keep them in the development environment and I have an extra DB with the custom name in the production environment for tasks that require somewhat temp tables that should...

Easy -yes. But it is 2 step process.

The following will generate a list of sp_addrolemember statements for each user of the role db_datareader to add them to db_datawriter role. Four...

This is really cool how you export a file.

Simon,

How do you export automatically?

Maybe you can add a line to your VBscript in ASP page that exports recordset field names into comma-separeted string like 

     For i = 0 To...

This is correct. I tested. You have to add a table name in Order By then it works. I compared estimated execution plans for both 2000 and 2005. In 2000...

I tested and foud out that if I connect to the local or remote 2005 server with either admin or low-privilege logins I have Reports enabled. But when I connected to SQL Server...

No, they will not ask you to reboot your computer.

Did you notice that the Help Desk people too know the answer before the computer is running?

The article is so...

Did not get it: BOL says that SSAS can use up to 3 GB when /3GB switch is used. You have to use /3GB switch in the boot.ini file.

Answer 2...

David,

if the column type for some columns is var-something, like varchar or nvarchar then only the actual size will stored. Example: your column is varchar(255) and you would think it...

Hi,

"Physical Database Files and Filegroups" article in BOL for SQL 2000 says that "All pages for system tables are allocated in the primary filegroup"

Since all procedures are  text that is stored in...