EasyBoy (11/12/2010)

---

When we are login to our development server we are getting specified cast is not valid error.

Can anyone please let me know what would be the cause/

I have attached...

Hardy21 (11/12/2010)

---

Yes there are 6 rows in the table and index_id = 1 (its primary key). In same table, there are other indexes that has statistic date and their index...

Hardy21 (11/12/2010)

---

Hello,

When I fire following code, few records has StatisticsDate as NULL though it is primary key:

select object_name(i.object_id), i.name, STATS_DATE(i.[object_id], i.index_id) AS StatisticsDate

FROM sys.indexes i

What...

hi

Try with Row_number() it will give you the line number in your case

eg:

Select...

On source server there is no space thats...

Hi

Database is in restoring state

No i...

Hi

It is not production it is local some one has deleted the...

Hi

Try With

Select * from INFORMATION_SCHEMA.<view_name>

this might have solutions for you

Thanks

Parthi

Try this

SELECT * FROM [ServerB].Tempdb.dbo.sysobjects

Thanks

Parthi

Hi

If you are not allowed to have link server then why do you want to query in serverB

You have to create link server...

vgtestingg (11/9/2010)

---

Hi Everyone,

I am working in SQL Server 2008. My database is displaying "Suspect" in front of database name. Can anyone suggest me, How can I remove...

Hi,

Find the below way i have tried

declare @Temp table (Changedate datetime, stepid int)

declare @Temp1 table (Changedate datetime, stepid int,Types bit)

insert into @Temp

...

Hi

You can have this way

declare @Temp table (EmpId int, EmpName varchar(50), MngrID int)

insert into @Temp

Select 1, 'aaa', 4

union Select 2, 'bbb', 3

union Select 3, 'ccc', 4

union Select...

Thanks. It Worked for me so what is the use of TextQualifier ?whether for...

HI

Did u run that script and had the tally table with you.I dont find any issue...