I want to create a new column with a default value. I create the column object, and the default object, but cannot bind the default object to the column before the column is added. The only way I can see of doing this is to add the column with AllowNulls=True, then bind the default, and […]
2001-08-08
3 reads
Hi all Ive found recently that the transaction log file for a database will NOT extend (even though auto extend is enabled) when a single transaction that is running hits the end of the log. I mistakenly thought that SQL*Server will extend the log when a space request failed. But if its the only transaction […]
2001-08-02
6 reads
Our networking group wants to decommission accounts in domain A, and create equivalent (named differently!) accounts in domain B. Is there an easy way to duplicate/copy/transfer the SQL permissions between the two different NT user accounts.
2001-07-23
2 reads
Hi all Recently I underwent some hair pulling planning over the disk-subsystem for our new production web-apps coming out soon. One of the big problems I have found is trying to architect a solution where I have 2 or 3 OLTP based applications (200 to 500 users each at times) all sharing the same "disk […]
2001-07-08
5 reads
Hi all I am whipping up my own script for backups (diff, full and log) with emailing, compression and deletion of files X days long etc (I will post when complete). I am having problems trapping the BACKUP command on failure... ie: set @v_starttime = getdate() BACKUP DATABASE @p_database TO vxtmpdump WITH INIT, NAME = […]
2001-07-08
9 reads
Comments posted to this topic are about the content posted at http://www.sql-scripting.com/sqlscripting/zip.asp
2001-07-08
1 reads
We have an internal application which when viewing the events through Profiler, I see a bunch of ODBC Stored Procedures. Basic sequence is create proc as.... and then the execute then it deletes the same procedure. The server is showing a bunch of compiles and my guess is these ODBC stored procedures are causing that. […]
2001-07-06
4 reads
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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