IT Professionals

[dev]

How to resolve 403-forbidden error?... I am not able to access few sites and I get this 403 error.

Dev

http://en.wikipedia.org/wiki/HTTP_403

PS, I guess it's coz of too much traffic... problem automaticaa solve aagidichu... Thanks...

[PARAMASHIVAN]

No Probes, Dev

[PARAMASHIVAN]

I am trying to do a bulk insert

BULK INSERT dbo.SSIS
FROM 'c:\conf2010 to be imported.csv'

but I keep getting an error saying

Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.

any ideas pls ?

[PARAMASHIVAN]

Kirukan or others

Does any one know where Relication details are kept (in which database adnin which tables) ?

I thought it would be in MSDB database, but I cant find any tables relating to Subscription, publishing and distribution ?

thanks

[kirukan]

Kirukan or others

Does any one know where Relication details are kept (in which database adnin which tables) ?

I thought it would be in MSDB database, but I cant find any tables relating to Subscription, publishing and distribution ?

thanks

Hope u got answer for this if not....

By default it will be stored in database called distribution in distributor database server.User can customize his own...
http://msdn.microsoft.com/en-us/library/ms189755(SQL.90).aspx

Kirukan

[PARAMASHIVAN]

Thanks Kirukan

BTW Do you know much about SSIS packages in SQL server 2008 ?

I have a package that Copies 10 tables from a Database on SQL server 2005 to SQL server 2008 .

Now I have chosen the option to Drop and recreate tables as well as delete rows in the destination tables before copying the data accross, this should eliminate Primary key violations right? but I am still getting them

any ideas

thanks

[venkkiram]

Anyone familiar with OWSM? If so, need clarification for some of my queries in understanding the conceptual design.

[kirukan]

Thanks Kirukan

BTW Do you know much about SSIS packages in SQL server 2008 ?

I have a package that Copies 10 tables from a Database on SQL server 2005 to SQL server 2008 .

Now I have chosen the option to Drop and recreate tables as well as delete rows in the destination tables before copying the data accross, this should eliminate Primary key violations right? but I am still getting them

any ideas

thanks

Ideally it shud eliminate Primary key violation...you physically drop the table and check the same.If it persist even after that then compare the structure of the source and destination tables...it may be a genuine primary key violation...we use SQL compare for this.....

கிறுக்கன்

[PARAMASHIVAN]

Thanks Kirukuan

I will compare the structures of the source table and destination table and see

[PARAMASHIVAN]

I have a contact table, and a course table. Now some of them have attended the course and some have not, how would I find the ones who have not attended the course ?

would be be contact left outer join, right outer join??

pls advice