That didn't work for me. I wasn't able to remove the spaces. Another option is to seperate the month, day, and year with DATEPART, and then string them all together in the report. However, I am having trouble keeping the month and day in 2 digit format for dates smaller than 9, and I need […]
2003-12-16
2003-12-16
1 reads
When you say a "batch file", there are at least two possibilities. One is you use the Scheduled Job feature of W2K. In there you can set the ID under which it runs and so provide a domain ID with suitable permissions. A simple way to determine if you have it right is log in […]
2003-12-16
1 reads
The command being executed is BACKUP DATABASE... and has been running since Dec. 6. There is a lot of CPUtime and DiskIO associated with the SPID, but I don't think there is anything to roll back. Is there any way to remove this orphan process (if that's what it is) without having to cycle SQL […]
2003-12-15
3 reads
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!
2003-12-12
Probably more than you want to know, but there's a paper () on this from the developers of the Index Tuning Wizard. --Jonathan
2003-12-10
Search the forums for a thread named 'Help me beat EXCEL' or something like that. Must have been activ in April. Can't help you with the actual thread ID, for I am not at work right now. IIRC, there were several solutions for your problem. HTH Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-10
I never look up first, I treat these questions as test questions to find out how much I do know to prepare myself for the exam. quote: I always answer without researching. Except for today. And if 60-something percent of respondents got this one right, it means they went and looked it up. (I look […]
2003-12-09
Can someone first please explain this row-level security concept and how it works. Is it an auto-filter that is controlled by some system stored procedure? Thanks, Johnny
2003-12-09
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!
2003-12-08
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