J:\ does'nt seem to be localdrive, Is it SAN Drive or Network Share Mapped locally?

Some Possible Causes are

1. Your SQLSERVER Agent Service Account does'nt have access to the location.

2. You...

Hi,

When you restart your SQL Server then memory will be flushed so it will work perfectly but gradually you will get this error once memory bottleneck comes...

My choice is to go for rebuildmaster and restore the recent backup... This saves time and lot of other issues!

Hi,

In SQL 2000 you will get query analyser, enterprise manager after installing client tools. In SQL 2005 you will get Management Studio and other tools after installing...

Hi,

You have specified that you changed the password for sa and forgot to disable which means you remember the password for sa correct?

If you want the port number of SQL Server remotely then just download "portQry.exe" from Microsoft and just run this command

portqry -n {windowshostnameofsqlserver} 1434

You will get the complete...

Ha ha.. That's why they kept "my"google... so you can keep any name because it is yours...

Hi Padma,

What I gave is just link in Google Search... Try Searching for "Setup Snapshot Replication in SQL 2005"... You will get some...

Then you need to use snapshot replication. Use this link to get some articles to help you..

Will SQL 2005/2008 Express edition help your need. Though you cannot have all DBA options in Express edition, It comes free with some options which can help you..

Hi,

Run this code in master...

select * from sysprocesses where program_name like 'SQLAgent - Generic Refresher%'

If your SQL Agent is running then you will get output else no...

Hi,

Sometimes you may need to add two single quotes when using strings in OPENQUERY... just recollect that..

Hi Gila,

Do you think it will be helpful if he can post the performance counter results so that it will helpful to find performance/IO...

Hi,

Are you sure that this error is happening in Microsoft SQL Server? Error seems like Oracle?

Hi,

Not sure whether this will help you... Put the below code into SP and call this SP from Job to send notification to you... UPDATE STATISTICS...