newbie question. I'm having a trouble trying to connect with Enterprise manager to a remote SQL server 2000, I con connect to the default instance using IP address (ths because SQL is in another subnet)but when I try to connect to IP_Address/Instance_name I've got back an error, that's works locally. Can you help me? Thanks […]
2001-11-16
5 reads
Has anyone implemented replication in a clustered sql server 7.0/2000 environment? What are some thoughts/issues on it? Can it be done successfully? Thanx. Bob.
2001-11-14
3 reads
Is there any way that a non 'sa' users can view and edit jobs in SQL2000?? thanks,
2001-11-14
3 reads
I have two detail columns that needs a column which accumulates for each and one that adds the last 12 months, also a column that takes those two totals and does a calculation. Can I do this in a sql query? Thank you!
2001-11-12
5 reads
Hello, A trivial task that is bugging me. I have a list of Keys that a multi-select dropdown in the frontend. I do not want to write dynamic sql to avoid generation of Query Plan every time I hit the DB server. How do I manange to get all rows corresponding to the Keys ? […]
2001-11-12
3 reads
Does any one have a script or an solution for how i can keep my data definition on my production db in sync with my develop edtion? Our programmers make changes only to the dev version db, how can i automate those changes to the production version of the database without loosing the data in […]
2001-11-12
I'm looking to write a stored procedure based on a Proxy log file. I have one field called URI. This field contains all of the different websites that have been hit as well as gif images and other items that are logged by an ISA server. I need to filter out anything that is not […]
2001-11-09
4 reads
It appears that setting the isolation level to 'READ UNCOMMITTED' slows down our queries over isolation level 'READ COMMITTED'. Has anyone had similar experience or know why this might be happening? Our application is OLTP and we have a reporting tool that sits on top of it. The reporting tool runs in 'READ UNCOMMITTED' mode […]
2001-11-08
3 reads
I need to output a query result in tab delimited format. I need the syntax. I use dbaseiii all the time and cvs once in a while, but I need to export this data using Tab delimited. Thanks
2001-11-08
1 reads
We have dataflex-files which is to be loaded into some sql-server tables. There are some columns which holds different kind of prices. The format in the dataflex-table columns is like 100,0000. When we're trying to load this into a column of the data-type decimal(10,2) something goes wrong. If the format instead was 100.0000 there would […]
2001-11-06
2 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