Firstly, every package has at least one version. However, there may be package log records for versions that don't exist. If you don't get any records when executing that query then none of the packages have package logging enabled. Try this VBScript that produces a list of the package logging properties for each package on […]
2004-01-22
Still curious if seperating the settings statements in a seperate batch but on the same connection works. You could also try setting the default connection properties on the SQL server, but that will affect all connections that don't explicitly set those values.
2003-11-20
1 reads
Interesting concepts. It's quite remarkable what you've achieved. I would definitely be interested in a more mature .dll that could be registered and used from SQL just like an API... that would be quite nice.. Cheers! JS
2003-11-03
Very cool; I'll try it out later today and let you know how it works for me.
2003-07-23
1 reads
2003-07-23
1 reads
I have to agree with Mark on this one. I've watched people intentionally not listen to my mother because she was Japanese. It didn't matter that she was speaking perfectly clear English with only a hint of an accent. Because they said to themselves, "I won't understand her so I'm not going to even listen," […]
2003-07-21
1 reads
Select ColName From TableName Where [IdentityColName] = @@Identity ColName is the name of the column with the GUID and IdentityColName is your IdentityCOlumn. Cheers, Crispin Something as incredibly simple as binary still gives you too many options
2003-07-17
I've made a copy of refiner.exe on the server and run the command from the server but get an error message 'Access Denied', although I thought I had administrator access rights.......could this error mean something else??? If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, […]
2003-07-08
This is all happening inside one explicit transaction: Begin Tran, Insert into Table1 (on connection1), Select max() from table1 (on connection2) then insert into table2 (on connection1). And yes, there are triggers involved. Triggers on Table2 could actually need to go back and update Table1. The developers tell me that they are not explicitly setting […]
2003-07-01
You've hit the SQL 6.5 hard limit of 64k bytes in a stored procedure. (this limit became about 250mb with the introduction of SQL 7.0). This is 255 bytes of SP text * 255 rows in syscomments. Your only real options are to streamline your SP, or break it down into functional (and reusable?) components. […]
2003-06-29
1 reads
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
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