Okay. Just went through this several weeks ago. This ended up being my solution. Because of the amount of events that I'm tracking I had to create a stored procedure because the set events went beyond the length of the Jobs window. Here is the header for the stored procedure. First step is to output […]
2005-03-30
"As per my experience, uploading file by natual DTS is so flexible. For example, the file name is not allowed to changed. "The name of the file can be changed by using the Visual Basic Active X Script functionality within DTS. Just send the output of the text file destination icon to the active x icon and […]
2005-03-30
HelloSQL Authentication, its normal user not belong to any group its a son of SQL server only I've just create it in Logins in EM and assigened it to 1 view only, Acctually he can read the data from that view, but also he can browse the whole other views design, even all DTS logic […]
2005-03-25
Lets look at your Question #2 a bit at a time.The datediff("D",CH1.CallDate,getdate()) was used to come up with the "age" of the call. If that is not what you meant by "age", you will have to clarify further.The CH2.CallDate > dateadd("M",-12,getdate()) clause was used to constrain the results to calls within the last year, as […]
2004-12-03
Hmm... I'm not sure I understood the question... are you asking how to mark all entries with duplicity, instead of leaving always one of them unmarked? If so, then try this:UPDATE e SET Dup = Yes FROM Employees e JOIN (SELECT FirstName, LastName, count(EmployeeID) FROM Employees GROUP BY FirstName, LastName HAVING count(EmployeeID) > 1) as […]
2004-08-26
Hi,Try change Aritmethic abort setting from connection property.1. Run SQL Server Enterprise Manager2.right klick on server, select properties3.select connection tab4. check mark on ANSI warning,ANSI padding,ANSI nulls, Aritmethic abort
2004-04-14
THANKS much !!! (Yes, it isn't that large a database when you think about, compared to the others we have on this system it is one of the largest).Obviously I need to do a couple of practice restores on dummy databases to get this down.My big concern was after 3 hours, and having no gauge […]
2004-03-31
There have been a couple of threads recently where a set of values is passed in via a single parameter. The query then does a charindex() in order to "parse" those separate values. That should work and you won't have to worry about extraneous parameters you won't necessarily use. K. Brian Kelley, GSEC http://www.truthsolutions.com/ Author: […]
2003-12-10
1 reads
Now why did the multiple spaces get removed? 'Have___a__Nice_day!' to 'Have_a_nice_day!' When I wrote this originally I was scrubbing some data that had a ton of problems like this. It had been converted by several someone elses before me and they had concatinated a bunch of fields with little to no regard for spacing.
2003-08-21
That's to complicated. This works beautifuly. declare @String varchar(255) set @String = 'Have a nice day' While 1 = 1 begin set @String = replace(@String, ' ', '') IF charindex(' ', @String) = 0 Break end select @String
2003-08-21
1 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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