Hi Krishnan,

Shrinking transaction Log is an iterative process as the active transaction log may be present. I have successfully used the following sequence of steps to backup and then shrink...

True that the Shrink transaction Log is not always is immediate. But, I have been successful most of the times by using the following sequence of steps.

BACKUP LOG dbname WITH...

We have also run into this same (well, very similar) error message on our servers not when doing backup but when server was stressed. What the SQL Server is telling...

With the following sample values you mentioned

=============================================

Plz assist me in choosing right data type in a table in SQL Server database.

I need to store values of following kind

12345.67890

1234567890

346656

56.67

Here precision is...

Hi Ramesh,

Table data type can be used only in the session it is declared. You can not access it directly outside the context of the declared session. The best to...

In my experience also it is always a good idea to use either Cascading or Triggers for the enforcing referemtial integrity and remove orphaned records. But, be careful and make...

The best way to send mail when a customer record is inserted is using a INSERT TRIGGER and xp_sendmail within it with appropriate parameters. You could use variables and queries...

By Deafult whn you define a Transformation (DTS Data Pump Task)it will append to the table. You do not need to do anything. If you happen to use DTS wizard...

This is another one of those inexplicable and weird error with MMC. Uninstall and Install is the best option ..

Good Luck

Did you validate and process the cube before trying to connect. The error "no rowset returned" is normally indication of the cube definition which does not fetch data. Using the...

I am not usre what you mean by using the "import data function within SQl Server". For the scenario you described I would use DTS Import Export Wizard or a...

Hi Ray,

Analysis services cubes can combine data from any number of sources and you can use DTS packages to extract data. Any reporting tool or frontend tool (including Excel) which...

I recently observed that the answers are being published next day. Using them is not my way of taking a test. If bragging is what you are using QOD for...

Lowell and Allen, The article by Brian and the Book online applies to the renaming a server as renaming the default nstance. Named instances always need to be dropped and...

I have used both User_name() and also System_User in different instances. Both functions return the same results for a SQL user account as long as it is mapped same. However,...