Each employee can have up to 5 records (5 PayCodes)I need to ensure each employee : their payamt of PayCode 2 =1.5 * PayAmt of PayCode 1.Example Table: For example:EmpID PayCode PayAmt 123 1 10 123 2 15 456 1 9 789 3 6500 851 4 40000 […]
2005-03-10
Nita,I would guess that the SQL Server Agent is attempting to log in to the SQL Server as sa.To verify, right-click on the SQL Server Agent in Enterprise Manager and select Properties.You will then see a Connection tab. You'll likely have this set for "Use SQL Server Authentication" with sa as the user. Just enter […]
2005-03-10
Is there any thumb rule which can be used to decide about this selection.Pls suggest
2005-03-10
Thank you one and all. I was a little leary about changing the DB owner to another Domain Account - even one that is a member of the local admin group and one that starts the Services. I kinda walked into a mess here and I have Databases 'owned' by 3 or 4 people that […]
2005-03-04
Yeah, that's what I figured...one of those hard-to-catch bugs (somebody should tell Steve or Andy, but they probably can't fix the office plugin). can you see this?
2005-02-25
Well after looking thru the books I saw Microsoft SQL Server 2000 Administrator's Companion and it looks good. It has a 5 star rating so would it be a good book to choose? Any imput would be great! Thanks
2005-02-22
Case Studio 2 turned out to be very good. It will also do data flow diagrams. I believe the price is around $400. It will do more databases than ERWin and is also extensible through templates that you can design if you are willing to do the work.The one drawback that I saw with it […]
2005-02-21
well if the procs work.. nothing. SysDepends is used when ou ask sql server to show the object dependencies (spa needs table1,view2 and vice-verca)... but this is not always accurate. So I guess the worst that could happen is that you delete a proc that is actually needed but that sql server "said" it wasn't.
2005-02-21
This function will increment the given alpha numeric string in sequential order up to 100 characters. (The length can be easily modified)
2005-09-22 (first published: 2005-02-14)
2,047 reads
Take a look at the SQL Server Health and History tool. It collects event log data into a repository database.
2005-02-14
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