Hello Guys,

I have changed the schedules for the jobs mentioned in my earlier thread, but still the users are complaining that they get disconnected.

Please let me know your ideas and...

Hello Carl / Studdy05

Thanks for the replies. Yes there are some jobs running during that time and some of them have been scheduled to run as follows:

1. Transaction Log Backups of 7...

Hi,

Please go through this link..

http://support.microsoft.com/kb/218172/

Hi Krishna,

Please check once the order by columns with their alias names.

FS.sdate, FS.Code

Hello,

Please go through this link

http://www.eventid.net/display.asp?eventid=17055&eventno=3647&source=MSSQLSERVER&phase=1

Hope it might help you.

Thanks

Hello,

Thanks for all your inputs. I will look up into the respective areas mentioned in your replies and will get back.

Thanks

Hi Gary,

This is the information given in BOL

Error 8908

  Topic last updated -- January 2004

Severity Level 16

Message Text

Table error: Database Id DB_ID, object Id O_ID, index Id I_ID. Chain...

Hello,

Try this query and check it out....

SELECT REPLACE(NAME, SUBSTRING(NAME, CHARINDEX('Pack', NAME), 4), 'Case') FROM dbo.Product WHERE (NAME LIKE '%pack of%')

Hi,

This is the information provided from BOL:

Changing Collation Settings After Installing

Collation settings, which include character set, sort order, and other locale-specific settings, are fundamental to the structure of all...

Hi wz700,

Thanks for the reply.. In which site, can i check the article? Please elaborate.

Thanks

Hi

If i am not wrong those are not databases but tables residing in a single database. If so

SELECT SUM(C.SALES) AS SALES, D.DISTRICTNAME, R.REGIONNAME

FROM CUSTOMER C...

Hi Alzdba / Reshu Mehta / Robert Stewart

Thanks for your replies. It seems he was asked to explain the technical usage of the listed terms with respect to SQL Server....

Hi,

Try these statements..

SELECT Replace ('MA7017A-T-TR-014', '-TR', '') AS Part

SELECT Replace ('MA7017A-T-TR', '-TR', '') AS Part

Hi Alejandro

This might be useful. From BOL,

OLE DB Provider for DB2

The Microsoft OLE DB Provider for DB2, distributed with Microsoft® Host Integration Server 2000, allows Microsoft SQL Server™ 2000...

Hi,

Try this one...

Declare @Tmp Table(UserID UniqueIdentifier, ActivityDate DateTime

 Primary Key (UserID, ActivityDate))