2003-07-02
ETL (Extract Transform and Load)
RE: Deleting a subscriber
Hi, try to delete all publications before 'diabling publishing' then it should work.
2003-07-01
RE: Identity Column
Hi subhashkvsql, quote: How can i modify an existing column as IDENTITY, similarly how can i modify IDENTITY property of a column to NULL if you know for certain that there are no duplicates in that column, simply make it an identity column via EM as pointed out before. As for the second question I'm […]
2003-06-27
1 reads
RE: MSDB reverts to Simple Recovery Model
Cheers. Just out of interest - why does it set this as default - is there a good reason? (I want to perform trans backups)
2003-06-27
2 reads
RE: Do you think education matters?
quote: You are not stupid! I love to hear things like these from a woman Cheers, Frank
2003-06-27
2 reads
RE: VP application with Oracle 8i
Hi ashokc, quote: I am getting following error when I ran my VB programe. Run-time error ‘-2147467259(80004005)' Oracle error occurred but error message could not be retrieved from oracle. Can any one suggest me how to remove this error. do you mean something like Err.Clear or On Error Resume Next? Cheers, Frank
2003-06-27
RE: Role permissions
I just created some interesting SP that gets as argument the role or user login and returns ALL permissions for that role/user into a table It is in testing but till now I am 100% works fine. It is kind of big but I can publish it if you want Regards LMT
2003-06-26
RE: Local system account vs Domain user
The main difference is basically that the local system account cannot access any resources on another machine. So ports from a shared network drive, backups to a network drive, using an Exchange server with xp_sendmail etc. won't work. So in your case if you're having linked servers you need to have a domain user account.
2003-06-26
RE: Who controls SQL language?
The SQL standard is referred to as ISO/ANSI SQL Standard; these two organizations control it. Most software vendors (including IBM, Oracle and Microsoft) have "extended" the standard, though Most SQL dialects are trying hard to be SQL2 (SQL92) compliant; some claim SQL99 (SQL3) compliance. In short: there is a standard controlled by ISO/ANSI, there are […]
2003-06-25
RE: DTS package won't run as job
I ran the package at the server console, not from a client. Mark Mark Hottinger
2003-06-25
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers