I did get to work and I did remove the single quotes from my varibles, its my hotmail acount that needed verification.

Anyway I have a differnt problem I am trying...

I had just set up a hotmail account to send mails from after going to that mail box it said that I should log in to verify account in order...

The error I get states

'Cannot insert explicit value for identity column in table 'TableName' when IDENTITY_INSERT is set to OFF.'

the ERROR_ SEVERITY is 16

when I run the query...

I was wondering has anyone ever written a regular expression thatreurns a boolean for wether a phone number is a valid phone number in the US or...

Many thanks for your help Howell also to Sean Lange, eveerything seems a bit simpler now and understandable.

I have to admit with some of my testing so far Sean's example...

Hi Lowel I don't quite understand your code it seems to be in VB as well. what I am trying to do is to create a User defined function CLR...

Thanks for the insructions I had problems where for some unknown reason I was unable to share Folders on my system. After checking online I saw where others have experience...

Having the same problem, could you please give a better explanation for your fix or a possble example. Don't understand, I am getting the same problem of the OK button...

"Did you started MSDTC, if not please start and allow inbound and outbound.

I think your problem should be resolved"

Hi guys in earlier post Raj suggested to turn on MSDTC,...

Just to mention,I did not see any inbound or outbound option anywhere, I am using SQL Server 2008.

Thanks a million Raj, this works I droppped all link servers, users and logins created by replication, started MDTC in Services and recreated the type of replication described in my...

Yes I have set data access to true as well , however I dont see why I should have to if the link server is created automatically for replication from...

I did have that before if you look at the bottom of my posting you can see where I said RPC is already set to True.

Thanks guys, managed to create a synonym for the table using the same name of the table, no when I select from it I get the results I need.

query...

Its just for practice I am not sure how to use a procedure with Cursor output,

I was trying to populate a tale variable with the results form the cursor output.

if...