RE: SQL Server 2000 and log shipping
and which version from sql server 2000 ? standard or enterprise ?
2004-02-18
Assembly
RE: The priority boost configuration option
I haven't really experimented with this, though I've thought about it. Much of what I've read in books and from the guys at Sysinternals seems to indicate that this isn't really a good idea. If nothign else is running then I'm not sure what a priority boost gives you.
2004-02-13
RE: SQL 2K on win 2003
What do the last few lines of your sqlstp.log report? It should be in %SYSTEMROOT%. You can go from SQL Server 2000 RTM (the CD) straight to SP3 without applying the others.... the Service Packs are cumulative.As for the initial question, we're running Win2K3/SQL2KSP3 Active/Active. Experiencing some issues with distributed transactions and MS DTC, but we're […]
2004-02-05
Linked Server and Missing records!
Ok, this is one of the strangest things I have ever seen. First thing, the background: we have a DB2 system that we want to take out all the records from a handful of tables and place the data in SQL Server. There will be some manipulation to the data; but, even before that the […]
2004-02-05
1 reads
Debuggin backup jobs
I used the maintainence planner wizard to build my backup jobs, daily differentials, weekly fulls, integrity checks etc.The jobs are not succeeding. No backs are being created and all I get for a message is "Last step to run was Step 1"Does this mean that step 1 was the last job to succeed? Or that […]
2004-02-02
RE: Access to View SQL jobs
Trace yourself in profiler while you look at the jobs.. That should give you an idea of the permissions you need. Without testing anything I am guess readonly permissions in msdb will do the trick.
2004-01-30
1 reads
RE: Converting Access Query to TSQL
Those Iif statements are a pain, and the best way I can think of doing this is to create a table called PersonCodeArea with two columns called SalesPersonCode and Region. Fill the table with data in the IIf statements so you get SalesPersonCode Region.SWI Central Region CENT Central Region SCR Central Region SEL East Region ... […]
2004-01-30
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