2004-12-07
data
Workflow question
In my DTS package I have two connections: GA2_remote, GA2_local Let's say I have a Data Pump.Then on successful completion of this data transfer I want to do another Data Pump with the same GA2_remote and GA2_local connections.Can I do that? If yes how do I control the workflow? How do I say SQL Server […]
2004-10-12
RE: Setting Up SQL Mail
Thanks for your reply... the default mail client is set to be Outlook 2000 and not express.Second, how do I modify the Sql Agent Mail properties? If I go into the services and open up the properities for the SqlAgent it doesn't give me anything... I am still confused because when I try to set […]
2004-10-07
RE: sql experts help!
http://www.sqlteam.com/item.asp?ItemID=5857 thanks! taking your suggestion, i did some research and found this.... very cool - maybe it'll help someone else out 🙂 thanks for everybodies help cheers
2004-10-07
RE: bitwise identity for static lookup table???
Cheers...But the size of the field isn't an issue the real question is creating the identity with LastIdentity2.Do you have any ideas?
2004-10-07
RE: Count day pr mont, year
ANavn cannot be null see http://www.cyren.no/diagram3.gif Shall i only put the SELECT DISTINCT GjelderFra FROM marsh_HKL.tblhertzkorttidsleiebiler, LEFT JOIN marsh_HKL.tblhertzkorttidsleieAvdeling ON FKBRAvdeling=AID --AND GjelderFra BETWEEN @datoFOM and @dataTOMin the first select or both?With this i get error: ******************************* Incorrect syntax near the keyword 'LEFT' *******************************
2004-10-07
Cannot add domain group
Hi folks. I have not seen the following before: I cannot add the security group ‘domainname\LADM SLEEC DEV’ as a login to SQL Server which complains that the group does not exist. If I use Enterprise Manager and attempt to add the user, I can see that the group does indeed exist in the domain… Now, […]
2004-09-27
RE: DTS and Nulls - Active X
There are no restraints I am aware of ... fields are money or character. Note: I get the Isnull error for all fields. Are you sure I can use this command passing it the DTSSource()?
2004-09-15
RE: Dynamic DTS
My post must have executed the same time as your followup.If you're using TSQL as your source of the data pump task, you can still follow the examples above. Dig around in the Disconnected Editor to see the properties available to you.To build on my previous post, you could convert all your Int types to […]
2004-09-15
RE: Linked server security
Sorry about that. Here is what the error message says:The server detected the following syntax errors in the command: Error 7314: OLE DB provider 'server2' does not contain table 'Rbc_datawarehouse.dbo.cmsbatch'. The table either does not exist or the current user does not have permissions on the table. OLE DB error trace [Non-interface error: OLE DB […]
2004-08-25
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