I am trying to setup a SQL server connection with ASP. I have done this many times in Access but am having some problems with SQL. The server is running localy on the web server. I am wanting to put values from the database into drop down boxes for use with other tables. I am […]
2001-12-19
3 reads
2001-12-18
We are receiving an error with replication because of our identity columns. We have been told about the "Not For Replication" option on the identity property but don't know where this option can be found inside the Enterpise Manager. Can this option only be used if you create the table by script? That does not […]
2001-12-13
4 reads
I was wondering how different DBA's migrated their changes to the production environment? Is there a product out there, that scripts it for you? Do you script it yourself? Do you use DTS to move the objects?
2001-12-13
3 reads
I'm looking for a good debate on why not to go with a fixed memory setting...my background is from Sybase and Oracle, which both use a fixed memory size. We have a dedicated SQL server box with 4 GB of ram. The only thing running on the box is SQL Server. I would like to […]
2001-12-13
2 reads
I need to copy most tables, stored procedure, and views from one very big production system to a small test server. I do not have room for all the data, so I cannot just restore a backup. Is there a way to create a script that will allow me to re-create all tables, sproc etc. […]
2001-12-13
6 reads
I setup merge replication between my PC and my Web server (I connect via DSL.) I setup the home PC as Publisher and distributor. When I add new data at the subscribing web server it is being overwritten by the home PC. Merge replication on a single Server works fine. I'm also not able to […]
2001-12-04
2 reads
work_id Work_item_code -------------------------------- 3 Sup 14 100001 5 100002 16 100003 8 IWSM 9 ES3000 10 AppDev 11 100004 I want to have a counter on this select like work_id Work_item_code counter ---------------------------------------- 3 Sup 1 14 100001 2 5 100002 3 16 100003 4 8 IWSM 5 9 ES3000 6 10 AppDev 7 11 […]
2001-11-29
3 reads
I have a web content management system that pushes a transactional replication from a staging server to a live server every hour. I want an "Accelerated Publication" process that triggers the replication process manually to force the publication early. I have identified the job under management jobs and have got my web page to trigger […]
2001-11-22
2 reads
I have configure merge replication in command prompt i.e MS DOS prompt. i used command prompt utilities lile replmerg.exe.This file asks the distributor, subscriber and publisher details. Publisher: pubs and distributor is also same server. Subscriber:nowthwind publication:pubs_north It gives an error message: The subscription to publication 'pubs_north' has expired or does not exists. Please give […]
2001-11-16
6 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