@SQLSACT, no i don't set

Thanks all of you for clearing my doubts

@gilamonster..Thanks for your reply, Now i just need to confirm that what option we should use for shrink database file with EMPTYFILE option?

1. Shirnk database file with EMPTYFILE...

Please try with UNC path of file location in bulk insert .

Sorry Gila,Now I got it what you want to say.

Thanks for reply.

If We don't take a full backup and try to take backup of transaction log file then sql server give a error "Msg 4214, Level 16, State 1, Line 1

BACKUP...

GilaMonster (6/3/2013)

---

writearjun53 (6/3/2013)

---

After transaction log backup, If we rerun the DBCC LOGINFO command then we will see how the Status=2 has changed in the file. The last entry is still...

After transaction log backup, If we rerun the DBCC LOGINFO command then we will see how the Status=2 has changed in the file. The last entry is still marked as...

run this DBCC LOGINFO(database_name) command , If status is coming 0 for any fileid then that fileid log file is not in use..

check log file name using this query

SELECT *...

please try with fully qualified host name.

Please try to Stop and Start sql server service using management studio to resolved this issue...

if you want all remaining model as it is then please try this query

SELECT

CASE

WHEN CARS.Model LIKE '%Ford%' THEN 'Ford'

WHEN CARS.Model LIKE '%Chev%' THEN 'Chev'

WHEN CARS.Model LIKE '%Buick%' THEN...

To fix this problem I did change the Named pipe value from below \\.\pipe\MSSQL$SQLEXPRESS\sql\query to

\\.\pipe\sql\query using SQL Server Configuration Manager.

By default SQL Server 2005 has TCP/IP connections disabled. To enable TCP/IP support, use the SQL Server Configuration Manager tool, select SQL Server 2005 Network Configuration, select Protocols, double-click on...

For monitoring the sql sqlserver,you can uses below procedure.

EXEC sp_who

EXEC sp_Who2

Regards,

Arjun.