2005-04-29
Python
RE: Automated SQL Server Installation
Basically it means that you install 1 server with the cd. Somewhere in the install you'll have an option to save the install to a script. Once the install is complete, you can use that script to install all 19 other instanses.
2005-04-29
RE: File Transer using SQL
1. Enable non-system administrators to execute the xp_cmdshell extended stored procedure in SQL Server 2000 as MS Article 8907752. Create a group and Grand exec xp_cmdshell permission to the group and add user to that group.
2005-04-26
SQL Server connection problem
hi,i have my application running as a service and there is SQL Server on another machine. Both the SQL Server service and my application service are started using Local System acount. Both the machines are not in a domain, they are in a work group. Can my application connect to the SQL Server using Windows […]
2005-04-25
2 reads
SQL7.0 - Database switching to Single user Mode
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2005-04-07
Gmail as a Personal File Server
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2005-04-07
RE: Force Order
I tried that but it didnt work for me.The data in the Select statement would pull in the order specified but would not update in the order required.
2005-04-07
RE: Performance problem with Text data type
You sort of hint that you are creating a new archive database and it doesn't already have records in. In which case another idea might be to restore a backup of your main database into the archive database and then delete the records you don't want. You would have a bit of tidying up to do afterwards though, such […]
2005-04-07
Coping Column Data between Tables
I want to copy/overwrite the date for each order in the production table from a restored table. The production table now has more orders in it than the restored table and I don't want to lose the new order dates. The restored table is on another database but I can copy that over as a […]
2005-04-07
2 reads
RE: BDS SQL Digger 2.0 Released
I would have rated it higher but it tries to log you in even if you didn't save your password. It would also be nice if you could select all databases without having to check each one manually.
2005-04-07
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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