Ravi,

try

BACKUP DATABASE QAS

TO DISK ='Q:\SQLBackups\QAS.BAK'

Hi Expertz,

Please help me with these posts............

http://www.sqlservercentral.com/Forums/Topic763933-65-1.aspx

http://www.sqlservercentral.com/Forums/Topic754722-65-1.aspx#bm757143

Make sure you don't have any conflicting primary keys.

Please help...........

Jinu try this:

select distinct

emp.First_Name,emp.Last_Name,emp.Middle_Name,

comp.employee_id,comp.request_dt,comp.numofdays,

comp.reason,comp.request_by,comp.approve_dt,

tech.First_Name+' ' +tech.Last_Name+' '+isNull(tech.Middle_Name,'') as REQUESTEDBY,

comp.approve_status,comp.approve_desc,

...

Try doing these

First:

In database property set query time out to 0, It's default vaule is 600.

Second:

In your connection string add "Connection Timeout = 0"

Third:

When you executing your stored procedure or...

Please help...........

Ken McKelvey (7/16/2009)

---

Try this:

SELECT DISTINCT

emp.First_Name

,emp.Last_Name

,emp.Middle_Name

,comp.employee_id

,comp.request_dt

,comp.numofdays

,comp.reason

,comp.request_by

,comp.approve_dt

,tech.First_Name + ' ' + tech.Last_Name + ' ' + COALESCE(tech.Middle_Name, '') AS REQUESTEDBY

,comp.approve_status

,comp.approve_desc

,COALESCE(approve.first_name + ' ' + approve.last_name, '') AS APPROVEBY

FROM employee_tbl emp

JOIN l_compoff_tbl...

Elliott,

What about Merge replication for bi-directional synchronization.

You may receive this error message when the following conditions are true:

• SQL Server 2005 or SQL Server 2000 is installed on a cluster.

• You are connecting to a SQL...

The issue was caused by a an sp that was running for a long time which did some indexes and some sortings....

Couldn't figure out what exactly it does...

But once i...

Ya had tried that

I killed the processes accessing the tempdb and the shrunk the data file...

And that worked....

Is this the case for every other databases should we kill the...

Check if the user has sufficient privileges to exec the jobs.

Check if he has these roles

# SQLAgentUserRole

# SQLAgentReaderRole

# SQLAgentOperatorRole

Check if the user has sufficient privileges to exec the jobs.

Check if he has these roles

# SQLAgentUserRole

# SQLAgentReaderRole

# SQLAgentOperatorRole

Actually a user had problem in installing SP2 so it caused error while installing SP1 since some parts of the SP2 got installed and the registry got updated.

Now we successfully...