SQL Server 2000 provides a secure administrative link between the Distributor and Publisher and I don't think changing the password of the account under which SQL Server runs has any impact on this especially as the two are on the same Server in your case. Cheers.
2003-07-11
1 reads
I get the same error, can't find in BOL why the syntax error. Anyway, what about this: -- First add an identity column... ALTER TABLE MyTable ADD MyNewIdentityColumn INT NOT NULL IDENTITY(1,1) GO -- Next, throw the old values into the new identity column UPDATE MyTable SET MyNewIdentityColumn = MyOldIntColumn GO -- Next, drop old […]
2003-06-17
Crispin, thanks. Is there any way to return the name of each of these tables, per user? E.g., if user A created a temp table (the longer life type), how would I be able to reference it in a select statement for example? Thanks
2003-06-17
Unfortunately, a lot of the bugs that are reported are the "lipstick on chicken" variety or complaints about shades of the lipstick used... One of the main reasons why those d%$# users irritate the heck out of you and why it takes admirable restraint on your part not to wring their .....
2003-06-04
1 reads
Two ways 1. Declare the employee columns as input params to proc, in asp before calling InsertAccidentRep call another proc to retrieve them from employee table and then pass them to InsertAccidentRep proc. 2. Do not declare the employee columns as input params to proc but instead declare them as variables. Select the variables from […]
2003-05-30
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers