2005-04-28
BCP
SQL DBA Position in VA Beach /Newport News area of Virginia
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2005-04-25
RE: Login failed for user ''''(null)'''' in linked server
check this articles. you need to set up security account delegationhttp://www.sql-server-performance.com/tb_kerberos_protocol_transition.asphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_24tv.asphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2gmm.asp
2005-03-03
RE: Super Sunday
I'm not too sure of the rules of American football however if you are prepared for a little foreign intervention try Rugby. If Rugby looks too sissy try Australian football. The Aussies don't like to waste drinking time so they seem to have integrated the best aspects of rugby and the post match punch-up into […]
2005-02-13
RE: Dynamic SQL problem
Don't make me feel < snip and switch to my online dictionary> embarrassed </snip>
2004-11-19
RE: Replication
First you should remove all the subscriptions to the publication (check sp_dropsubscription, sp_subscription_cleanup, sp_droppullsubscription), then you should drop the publications (with sp_droppublication) and then you can disable replication in the distributor/publisher, you should use the wizard here.Check in BOL for exact parameters.
2004-10-20
RE: Wait Type OLEDB ... Bad DTS
You did not mention the nonSQL db you were accessing. Also, how long is it hanging? Have you tried setting/varying parameter "fetch buffer size"? Have you tried splitting the data pump task into 2 tasks (nonSQL db table -> file -> SQL db table)?I experienced the same hang/stall at the end of a data pump […]
2004-10-12
RE: SQL SERVER 2000 trigger for Audit trail
Something like this should get you most of the way: create TRIGGER [name] ON FOR INSERT AS update set created_by = SUSER_SNAME(), last_modified_by = SUSER_SNAME(), date_created = GETDATE(), date_last_modified = GETDATE() from inserted where .Seqno = inserted.seqno; create TRIGGER [name] ON FOR UPDATE AS update set last_modified_by = SUSER_SNAME(), date_last_modified = GETDATE() from inserted where […]
2004-07-29
RE: Utilizing AWE
Don't use AWE with only 4GB of memory in the server; use just /3GB. AWE is for managing memory above the 4GB boundary. --Jonathan Edited by - Jonathan on 11/14/2003 11:23:08 AM
2003-11-14
RE: SENDING EMAILS USING MULTIPLE MAPI PROFILES
Hi, It works !!! I think the key to this one is you stopped the mail service before specificing a new profile as it also works now without sending a password. Thanks once again. Mike
2003-11-14
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