If you are using a remote login in a linked server, that login does not need to be transferred to your new server, just create the Linked Server with the same details as the old server. I don't remember if it is possible to script the Linked Server details, try searching this forum or the […]
2003-07-23
1 reads
Personally this is an ongoing problem, I have it in the 2K EM in SOME cases. Probably MS trying to save some overhead, but I would think if I click REFRESH it would. KlK, MCSE
2003-07-22
1 reads
Often an outer join will do it. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-07-21
Hi accent-atlant, quote: Do you test it on 1000000 row??? I have slow perfomance... I guess it should only be a work around for a missing ident column. Sure, that you will run into performance issues with million row tables. BTW, interesting homepage (not, that I have understood too much ) Cheers, Frank
2003-07-21
1 reads
Hi Crispin, Thank you for the consideration. I do not have any identity column in my table. I think I have mis-leaded you. Actually my question was, does we have any means to get newly inserted value of uniqueidentifier column which is inserted by database from the function NEWID(). My application doesn't know what value […]
2003-07-17
2003-07-11
MS says they resolved this in SP1? Are you still getting the error
2003-07-10
The problem is that this extended stored procedure, though it can be executed by public (and since guest is required in master this means anyone who has login rights to the SQL Server), the extended stored procedure runs under the context of the account specified for the SQL Server service itself. That means if you […]
2003-07-10
First, construct a view to substitute all NULL values in the fact table by a value. I am using '-1', since I guess this will not be present in the Currency table yet CREATE VIEW FactView AS SELECT IsNull(currency_code, -1), <All other required fields> FROM General Now, create a second view on the Currency table […]
2003-07-10
Hi GENKO, quote: Hi, i've build a site with asp and access 2000 db, i've used a lot off filter for update and extracting record from my tables. Now i'm going to think to convert it in sql server, and my trouble is.....can i maintain the filter like in access 2000!?!? if you mean whether […]
2003-07-09
2 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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