I did read the article. Nice one.

But it explains why i can use only 8039 bytes of actual data out of maximum 8060 bytes per row allowed.

Still what happens to...

Give a brief list of some of the tasks being done by a DBA. refer to SQL Server 2000 Operations Guide on MSDN ( http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/sqlops4.asp&nbsp

Are you using only  Windows authentication model ?

IF No, then specify the username and passwords for Sql accounts in ASP code.

If YES, then grant login to ur SERVER\IUSR_SERVER account...

to reduce the SQL database log size, you could have used enterprise manager or use TSQL commands like

backup log  <DBNAME> with truncate_only  ( or to some backup device !!...

What exactly is "total information" of a database that you are looking for ?

Is it the information showed in SQL EM ?

Amit

You can always use where clause to filter out the data. That is as good as a paramater.

Partitioned view requires that you have check constraint on each table of view.

create...

Run that proc again. Let it hang again. monitor the server locks during the execution period. specially sp_who and sp_lock

If possible post results of your findings.

Can you also implement a feature of Closing a discussion?

Anyone of following can mark a discussion as closed.

1. member who started discussion

2. Moderator

3. Admin

4. Any other Superuser levels...

SQL Agent runs on server machine.

So it looks for thos files to be available locally. which it does not and hence job fails.

Solution.

A. make the FoxPro files available on...

/* To automatically close a db when no users are accessing it */

ALTER DATABASE pubs SET AUTO_CLOSE ON

go

However when u use the db , it will be opened again !

so...

If you refer to DBCC SHRINKFLE help

it says

TRUNCATEONLY : Causes any unused space in the files to be released to the operating system and shrinks the file to the...

after IE clearing history & cleaning temp folder & few refresh attempts, it is working again.

Somehow, I am not able to reply to any of the topics. It gives me a error in my browser (IE 6).

Error message is

Line: 2

char: 1

Error:...

Use dtsrunui command to generate your command line for SQL 7.0

This will be syntax error free.

Few things notices.

1. Login / Sign Up options remains in Top menu even after I logged in.

2. Top Menu font size & colour combination should be improved.

3. I...