Service has been started? Whats the error in error log? anything in the application eventviewer?

Hi GulliMeel

Thats the trick. You made my life easier. Thank you very much!!!

Thanks,

SQLZealot

Please find example as below:

Create Table T11(TXT nvarchar(100)

Insert into T11 Select '?? ??_1'

Insert into T11 Select '????????•_1

'

Select * From T11

Select unicode(txt),ascii(txt) From T11

Thank you for your help!!!

Importing...

Your question is not clea. Are these two datasets associated together? Do you want to have page breaks for both the sets? Could you please give us examples?

I dont think there is way to do this upto 2008 versions. But 2012 provides a way to get the resultsets handy.

Which version you are using?

it should be because of the precedence getting changed using the brackets.

http://blog.sqlauthority.com/2012/04/01/sql-server-a-puzzle-illusion-confusion-april-fools-day/

Grant Fritchey (4/3/2012)

---

I wouldn't use a linked server within SSIS. It should be able to connect directly to both servers in question. Is that the cause of the problem? Not...

Ok, I had an impression it would take...

Why not satire? Points only to "Practical Joke" is not justified.

Lost 7 points anyway.

Perfromance is one area you may need to look here. If the table is undergoing huge transactions(insert/update/delete) then it would be a concern area for you.

For old entires, I am afraid there is way to get it. Atleast for future, you can create DDL triggers on those procedures you may need to have a tracking...

Could you please elaborate the points for not doing the shrink on log files...

I guess the following can be used for modifying date. However not sure capturing the user who changed it and the entire track of it(only the last modifyed can be...

It would fetch all the values who has either of 0,1 or NULL. Why do you want to achieve here. Why cant you have the ColumnB = the value that...