2003-07-30
1 reads
security
RE: How much time each task takes
My SQL Server tells me that package logging is only available in 2000. I'm running SQL 7. Nice idea, though.
2003-07-29
1 reads
RE: xp_getfiledetails
Hi Wes, you get a result similar to Alternate Name (null) Size 83886080 Creation Date 19970627 Creation Time 90233 Last Written Date 19980312 Last Written Time 204127 Last Accessed Date 19980312 Last Accessed Time 204127 Attributes 32 ?? Haven't dealt much with it, but I think there are API functions like GetFileTime you can use […]
2003-07-29
RE: Single User Bug????
Are you getting any error when run SQL to make it 'single user' FALSE OR Changing from EM??
2003-07-29
RE: SQL Agent won't start
is agent running on "local system" and did you remove "builtin\administrators" ?
2003-07-29
1 reads
RE: UPDATE Query problem
this is for a text field. the 3rd argument needs to represent a multiple length string and up untill this point I thought % would do this. example: SUBSTRING(FIELD,3,%) 'should return the following: CR20AB = 20AB CR509FDS = 509FDS
2003-07-28
RE: Help Reqd for Optimization
No problem. I guess I have a bit of a prejudice against cursors in stored procedures...
2003-07-25
RE: How to insert data containing ', /, etc
Hi Zambrtp, quote: Would that always insert a tick ....this has only occurred once so far...if it always inserts a tick then the data would not be correct.. My insert statement passes the VALUES as ''('values','values')'' so that the insert statment is bulit as values ('values', 'value') in here is where the data had the […]
2003-07-25
RE: System stored procedures
Are you sure it wasn't Quest software's Spotlight on SQL? Maybe an eval version was installed?
2003-07-25
RE: Creating Extended SP using Visual Basic
You can do as a5xo3z1 suggested. Create an Active-X DLL in VB then use the sp_OAxxx procedures to execute it's method(s). I've done it several times and it works great.
2003-07-24
1 reads
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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