Hi San,

We know that log is being used by SS to record transactions taking place.

Even the commands which you have run was also logged in the same log file....

Hi San,

You executed sp_helpdb ('DBname') and got LOG file size as "160832 KB (Size) growth (10%)" i.e 157.0625 MB

and when run "DBCC sqlperf('logspace')", got

"157.0547 (Log Size in MB),...

Hi,

It is advisable to keep seperate backup of all Stored Procedures and Functions, so that they can be used whenever a case arise.

Also, sometimes the backup is of large size...

Hi,

It is advisable to keep seperate backup of all Stored Procedures and Functions, so that they can be used whenever a case arise.

Also, sometimes the backup is of large size...

Thanks for your reply.

I still feel that real cause of enhancement of Architecture of SQL Server 2005 is need to be find.

If anyone help in this regard, welcome.

Thanks Gail and Allen for this learning discussion amd information sharing.

Thanks a ton. Bye

Ankur

Thanks Gail and Allen for your generosity.

"

Clustered index determines the logical order of the data, not the physical"

But at link:

http://msdn.microsoft.com/en-us/library/aa933131(SQL.80).aspx

The very first line explains that:

"A...

Lot of thanks to you guys.

One thing more- Allen you said if clustered index are built without UNIQUE word "DB engine adds a 4 byte uniqueifier column", please you...

Thanks Grant and Allen for your valuable responses.

Does it mean Clustered index created on Primary Key is same as Unique Clustered Index?

Also it is said: PRIMARY KEY constraints create clustered...

Thanks Mr T-SQL for the response.

I will definitely run DBCC CHECKDB and check the integrity of this database at night.

Bye,

Ankur

Hi All,

FYI..

SQL SERVER 2000 EE with SP4 is installed on server.

This database is of size 9.7 GB and with log file of size 2.8 GB.

This message was logged when...

Please clearify it further. What problem are u facing while restoration of db ?

Hi Ajay,

AFAIK, if we need to change the collation settings at SQL server level, we have to reinstall it, but change in database collation settings doesn't require reinstallation. ...

Hi KD,

Does any object is dependent on this db? If so the collation settings can't be changed.

Disable that dependency and then try to change the collation. Hope it...

Hi

Agreed with LeeM, most of times it is Firewall which is hindering the connection to SQL Server.:-)