Hi,This error may also be returned for protocol and service queries, and means the specified name could not be found in the relevant database. This is the installation policy of...

Give user access (can be a windows or sql user)the public permission as public.Check in the properties then permissions.

Hi,You can configure smtp mail by asking your system administration.By the way are you using Microsoft Mail like outlook etc or Lotus (IBM).If it is Microsoft mail than u can...

(a)You Create Daily Backup Information

Instance Name Hotbackup Starting Time Duration Media Backup(if any)

(b)OS Info

Average CPU Load

Max CPu Load

Total No of processes

Log verification for any errors/warnings

(C)Database Info

Database Status

Backup Verification

Database Growth

Cache...

Hi

I have been running transaction replication for our sql server 2005 standard edition trouble free for almost 2yrs now and there have been only once a error was reported...

hi Ken,

Mine is production environment ,EnterpriseEdn SQL Server2005 instance is running.

Fragmentation of tables(both heap and non heap) indexes in one of databases(App 10GB in size) is so high, that...

Please find the required table structure attached.

Thanks

Hi Experts get rid of them and use Begin...End for the If), change the Not Exists by reversing the logic and using Exists, then I'd get rid of the inline,...

Thanks expert if you can write and post it would be great help and can you tell me what is the difference between then replacing with begin if you you...

Hi Experts,

Sorry to interpret......but am also stuck with a similar issue!!!!

we have Scheduled a Job in SQL Server 2005 ManagementStudio enterprise edition SP2.

Sometimes it fails with error :

Unspecified error occured...

XP_sendmail requires first to configure MS outlook to send and receive mail.then you can test please write xp_sendmail 'krish@mail.com','test message subject' query analyser result pane must give sent mail.

Hope this...

This error is coming in event logs..