Hi,

Right, i've fixed it without the need to do the reg clean as Dev suggested (although this does need to be done at some point).

The fix was rather simple as...

I let the installer configure with the defaults. Maybe that was my error! 😉

Hope to be able to give this another go at some point later today.

Thanks ok, i'll give that a go when i get chance and report back on the results.

Have you got a reg cleaning utility you would recommend?

Hi Dev,

Thanks for that, I did try uninstalling all components, reboot the machine and try again and still got this error, but i didn't clear out the SQL Server directory...

Hi,

If i understand it correctly you want to restart the identity counter?

See this: http://msdn.microsoft.com/en-us/library/ms176057.aspx

You can reseed the table to achieve what you are after.

Thanks,

Simon

Hi,

I would suggest that you check the Server/Database collations. You may well find that they are different which may explain the anomaly you are seeing.

Thanks,

Simon

Ok cheers Gail. I'll do that. Thanks for your help guys.

Thanks,

Simon

Hi,

I'm not using the normal sql server logshipping setup so your queries return no results. This is a custom solution to get around a restriction whereby our support server isn't...

Hi,

Well it's not your regular run of the mill logshipping i'm afraid. Essentially, logs are shipped from a live environment to a DMZ, the files are copied using robocopy from...

Hi,

I've not tested this but try:

INSERT INTO tblTraining

SELECT EMPID, 9750, 'NT'

FROM tblEmployee

You should still be able to get at INFORMATION_SCHEMA though...

http://msdn.microsoft.com/en-us/library/aa933204(v=sql.80).aspx

Hi,

Try something like this:

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CONTRIBUINTES' AND COLUMN_NAME = 'DT_CADASTRAMENTO')

ALTER TABLE dbo.CONTRIBUINTES ADD

DT_CADASTRAMENTO datetime NULL

ALTER TABLE dbo.CONTRIBUINTES ADD CONSTRAINT

DF_CONTRIBUINTES_DT_CADASTRAMENTO DEFAULT convert(varchar,getdate(),120) FOR...

Thanks! That helped me to get it working.

I set the dynamic connection to have a static connection string first and removed the expression. Once i'd managed to OK that dialog...

kramaswamy (11/1/2011)

---

Without going too much into your problem, if you're already able to use your dynamic connection manager settings to work with the Execute SQL task, you could just use...