RE: SQL Server 2000/ SQLXML
That's the one. Only avaliable in 2K South African Edition. Cheers, Crispin
2003-06-09
security
RE: SQL Server 2000/ SQLXML
lol. If this topic turns to rugby, you'll have most American viewrs searching through BOL for the RUGBY function Cheers, Crispin
2003-06-09
RE: Blob insert
I would appreciate if you publish the small conversion. Sounds interesting Thank you ps. we just have an issue with an image database and I would like to check this out
2003-06-08
RE: alternative to nolock to avoid blocking trans
Most of it is generated in stored procedures. I want to honor other locks that are on the data. But, while those locks from other procs are in place, I want to be able to read the data and be sure not to issue locks...except perhaps on schema. I don't want to issue any new […]
2003-06-06
RE: DTS Package Create Permission
Any one in the Public role can create the DTS package. But the execution success depends on what they are going implement in it. If your DTS package creates objects and data transfer it will fail since only dbo or DDL Admin can create the objects
2003-06-06
RE: DBAs versus SQL Server
We have hundreds of servers (600+) here, over 100 SQL Servers, who knows how many dbs. In Operations we manage about 55 servers (about because we only do backups on a few, not really manage) and do patches, upgrades, backups, and help troubleshoot. There's me and a junior DBA who does a lot of other […]
2003-06-06
RE: DBAs versus SQL Server
Interesting subject! It is my belief that there are several types of Database people: DBA = One who owns the hardware, software and network requirements. Also providing needed services like Back-ups, Patches, etc... DBO = One who creates and maintains scheme and DATA. This person also provides customer liasons if a project/product manager is not […]
2003-06-06
RE: Global Variables - For Path & File name
Hi Daniel, Yes you can...! DTSGlobalVariables("File").Value=DTSGlobalVariables("path").Value & DTSGlobalVariables("fileName").Value JFB
2003-06-06
RE: Copy values from col1 to col2 in SAME table
Thanks folks, I bet you're glad everyone's not as stupid as me 🙂 cheers, yogi
2003-06-06
1 reads
RE: new hardware
Cross, It's you versus the bean counters. I can't tell you what to do, only what I'd do in the same situation. For the low end scenario I would go for the minimum spec that I would accept, NOT the minimum spec that accounting will accept. If management want to shave things thereafter then it's […]
2003-06-06
1 reads
Blogs
Monday Monitor Tip: Compliance Checking for Old Versions
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
The Only Valid Test of a Backup is a Restore
Please, let me reiterate: The only valid test of a backup is a restore....
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