Hope, my article will help you on this.

http://venkattechnicalblog.blogspot.com/2010/12/data-compression-in-sql-server-2008.html

Cheers,

Venkatesan Prabu .J

It's not a bug. Sometimes, if the authentication mode is goofed up (it's just a configuration in the registry) by the sys admin people.

Your sql server won't be part of...

drop table sample_table

create table sample_table (id int, dat datetime)

insert into sample_table values(1,getdate())

select * from sample_table

select id,dat from sample_table where datename(month,dat)='June'

-----------------------------------------

id ...

select system_user

will provide you the exact user who logged into the machine.

Cheers,

Venkatesan Prabu .J

http://venkattechnicalblog.blogspot.com/

Possibilities are ,

1. Check for the deadlock on the object involved.

2. Very poor indexes on the table. There could be huge table scan.

3. Check...

I am writing an article on this. Hope, it will very useful to you.

drop table holiday

CREATE TABLE holiday (date DATETIME ,HolidayDetails VARCHAR(100))

INSERT INTO holiday VALUES('1/1/2010','New Year')

INSERT INTO holiday VALUES('1/15/2010','Pongal...

In that case, there is no need to specify the collation,

COLLATE SQL_Latin1_General_Cp1_CS_AS

correct me, If am wrong in my views.

Thanks,

Venkatesan Prabu .J

I have written an aricle on this. Kindly check it.

I have written an aricle on this. Kindly check it.

http://venkattechnicalblog.blogspot.com/2008/09/excel-column-is-greater-than-255-in.html

Regards,

Venkatesan Prabu .J

http://venkattechnicalblog.blogspot.com/2008/09/excel-column-is-greater-than-255-in.html

Regards,

Venkatesan Prabu .J

Getting response after 25 days.. I have successfully completed the project and its deployed.

Anyway, thanks for your response.

I have written a short article regarding this.

Please check my blog and provide me your valuable feedback.

http://venkattechnicalblog.blogspot.com/2008/09/list-out-all-tables-and-row-count-in.html

Congrats......... my wishes for your achievement.

Regards,

Venkatesan Prabu .J

Thanks Gila,

Thanks for your advice, I know that everyone is buys 😀

even i am also busy with my works. I dont want to waste my time.. 🙂 by...

Sir,

Do you think I dont know this query to fetch the data from two tables.

I have posted it in SSIS and I need some input in SSIS.

Regards,

Venkatesan Prabu .J

SQL...

I wish to share my views regarding this.

Please wait for a while and go for SQL Server 2008.

Its advisable to do certification on advanced updated softwares.

Any way I need to add more value add to this topic...

For opening sql server window from run..... sqlwb

For SSIS or visual studio .... use devenv