Shrink the log file.

You can use Import Export wizard, where you can specify the source database & table and Destination database and table( or create the new table in destination database )

It true that when we define the primary key by default it create the clustered index, but its not true you can define it as non clustred index also.

Primary...

Check whether db2 is mapped with user or not?

Hi,

Check whether u have set the configuration to start the sql server manually / automatic.

Regards,

Abhijit More( MCP )

How could we recover the database if my transaction log gets corrupted / anything will happ.

Suppose I have FullBackup say, Full1.bak

after this i have taken the differential backup say,...

SELECT object_name(id), text FROM sysComments where text like '%CREATE VIEW%'

you will get the definition from text copy it to Query analyzer, update the view definition as per your requirements.

-Abhijit(MCP)

You can do one this modify the view using definition and recreate the view.

thanks it worked, i used....

SELECTCAST( DecryptByCert( Cert_ID('DBCert'), Status ) AS VARCHAR(50) )

FROMdbo.Status

You are suppose to post the forum for SQL Server 2005 in this section

We get the details using xp_logininfo, sp_who2.. i think i need to explain you the scenario a little bit more...

Okay.. I have Server say 100.100.100.2

Different developers are accessing the server....

Thats true i want to know the Windows NT Users (log on name) whoare connected to SQL server we got the machine name from HOST_NAME() functions, but I wan the...

Hi !

You can also use apex SQL trial verison for comparing schema of objects betwn 2 DBs.

Hi !

Increase the lenght of your column.

Gail I didn't get you, can u tell me then why there is no diff in Execution plan.