I may have found the answer to my problem. I still needed to add user rights to the account I was using to start up the services.The user rights I added are : Act as part of the Operation SystemIncrease QuotasLog on as a service Replace a process level tokenAre there any other user rights […]
2005-02-20
Hope you all got the invitation. if not forgive me and send me a mail to my gmail id
2005-02-20
Actually, there is an FAQ on this site that deals with something quite similar to your problem. Visit: http://qa.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=3&faqid=364 As an aside, I've been a member here for a couple of years and only noticed the FAQs for the first time ever today - perhaps there should be a section in the newsletter about them? […]
2005-02-19
Linda how big is the budget If you can go to SAN disk then SAN replication is your best bet!If that is too expensive the you can try the Doble Server Logshipping solution I posted aboveIf still too expensive then you will have to work with your vendor and see if it is posible to work […]
2005-02-18
Frank, that is a nice solution. I typically use "IN" instead of "EXISTS" - which I am trying to get away from. Anyway, your "EXISTS" statement is confusing me so I was hoping you would elaborate on why it works (I tested it an know it does).I understand that because of the t1.EntryDate < t2.EntryDate […]
2005-02-18
That will most likely be the day I stop using SQL Server and make the move to Oracle. I've been weaning my developers from using constructs such as T1 left outer join T2 on..., left outer join T3 on.., and getting them to use T1, T2, T3 where T1.Key *= T2. Key and T1,Key *= […]
2005-02-18
We are also in need of this information. I would appreciate if we get a solution to this problem. Please let us know which option to choose.ThanksVipin Kedia
2005-02-18
2 reads
There always will be 3 accounts per fund and NULLS are not allowed for the accounts' IDs.Each of these 3 accounts are for some default behavior for a particular fund (i.e. Cash Account for Revenue). How could this information be normalized?I appreciate your help!jmatt
2005-02-17
You have two options.Option 1 If you absolutely have to have the information in Excel because of formatting or data placement requirements. What you do is create an empty Excel file on your workstation with all the required formatting, etc... then copy that to the server. Your ActiveXScript would then make a copy of this […]
2005-02-16
I can do this: Declare @AcctNo varchar(10), @LName varchar(20), @AuthPerson varchar(20), @PUCo varchar(3) But is something like this not possible? Set @AcctNo = 1, @LName = 1, @AuthPerson = 1, @PUCo = 1 I have a bunch, and I can't seem to figure out how to put more than one on a line to save […]
2005-02-16
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