RE: Once again subscription mail
Well, I received this missing mails, but again since Saturday 23:00 PM here no mail. ??? Cheers, Frank This mail didn't make it through either Edited by - a5xo3z1 on 08/10/2003 11:50:42 PM
2003-08-10
1 reads
automation
RE: Can't edit SQL data through access after save
The table has a unique primary key, which is an int, identity with step value of 1. All the rules as far as I know are correct (as far as I know). S.
2003-07-29
1 reads
2003-07-28
RE: Workaround needed to run sp_addlogin
You can create jobs using Enterprise manager. Go to your server->Management->SQL Server Agent->Jobs. You can add a new job. It acts much like any scheduler kind of stuff. You can set general properties and add one or more steps (tasks). For your problem, you would need a Transact-SQL step that calls a stored procedure. To […]
2003-07-02
RE: How much do you earn?
quote: I just find it hard to believe that the market could have slipped down to one third of the going rate six years ago! Hungry, out of work developers offer themselves at desparately low rates, before giving up and changing careers. I think the government should implement rate subsidies for developers, just like crop […]
2003-06-20
2 reads
RE: SQL Server Agent fails to start - no error msg
Hi Csaba, quote: Frank: I think this is the only thing left that I will try. I will reinstall the server. The only problem that it's in Romania (I'm in Hungary) and lot of people are working on it. However I can't do anything else than completely reinstall it. reinstall should only be the last […]
2003-06-20
1 reads
RE: How much do you earn?
Hi bond007, quote: Contracting rates in the UK vary quite a bit as well, the lowest i've seen is £15 per hour, the highest around about £80 per hour. that is ridiculous. When I was programming, they'll charged a fixed daily number of 800 - 1000 Euro. Who is willing to do this? They should […]
2003-06-19
RE: shrink logs
The script below will solve your problem,it runs for bot sql 7.0 an sql 2000. -- Caution : database compatibility level must be 7.0 or higher .. dbcc shrinkfile ( [Logical Log File Name], truncateonly ) backup log [Logical Database Name] with truncate_only GO if exists ( select * from sysobjects where name ='tmp_00000000000001a') drop […]
2003-06-19
1 reads
RE: data transfer between 2 sql
You can try configuring the web sql as a publisher and a distributor. Don't allow anonymous subscriptions, but define your LAN sql as an allowed subscriber. Then try a creating a pull subscription on the LAN sql.
2003-06-12
RE: DBAs versus SQL Server
Our company has over 60 SQL Servers and only 2 DBA's. Even if you automate all the maintenance, monitoring, and patches/service packs, etc., you still need people to support the servers. Thank you
2003-06-04
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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