-
13th October 2010, 04:40 PM
#101
Senior Member
Veteran Hubber
Originally Posted by
PARAMASHIVAN
PS, I guess it's coz of too much traffic... problem automaticaa solve aagidichu... Thanks...
“The real contest is always between what you've done and what you're capable of doing. You measure yourself against yourself and nobody else.” - Geoffrey Gaberino
-
13th October 2010 04:40 PM
# ADS
Circuit advertisement
-
13th October 2010, 05:44 PM
#102
Senior Member
Diamond Hubber
No Probes, Dev
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
14th October 2010, 04:07 PM
#103
Senior Member
Diamond Hubber
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 ?
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
19th October 2010, 04:49 PM
#104
Senior Member
Diamond Hubber
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
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
24th October 2010, 08:52 PM
#105
Senior Member
Senior Hubber
Originally Posted by
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
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
-
25th October 2010, 04:07 PM
#106
Senior Member
Diamond Hubber
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
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
25th October 2010, 08:31 PM
#107
Senior Member
Diamond Hubber
Anyone familiar with OWSM? If so, need clarification for some of my queries in understanding the conceptual design.
சொல்லிச் சொல்லி ஆறாது சொன்னா துயர் தீராது...
-
26th October 2010, 12:06 PM
#108
Senior Member
Senior Hubber
Originally Posted by
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
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.....
கிறுக்கன்
-
26th October 2010, 02:42 PM
#109
Senior Member
Diamond Hubber
Thanks Kirukuan
I will compare the structures of the source table and destination table and see
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
29th October 2010, 03:56 PM
#110
Senior Member
Diamond Hubber
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
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
Bookmarks