Before you decide on either Replication as your failover, please keep the following in mind: It doesn't replicate jobs, alerts, default values, constraints, triggers, primary key definitions and a host of other items. Identify solutions for all of those first.
2003-06-06
try this: create table t(x int,d int) insert into t(x) values(1) insert into t(x) values(2) insert into t(x) values(3) insert into t(x) values(4) select * from t declare @x int set @x = 0 update t set d=@x,@x=@x+1 select * from t drop table t Gregory Larsen, DBA If you looking for SQL Server Examples […]
2003-06-05
Here is one easy way. alter the table adding a identity column update the original column setting it to the new identity column then drop the new identity column.
2003-06-05
If you want exact copy and as long as you can see in EM both servers: 1. Setup DTSTask_DTSDataPumpTask with source MSDB database on the source server - destination MSDB database on the destination server. In source Tab you can type in sql query window a select statement with where condition of your choice which […]
2003-06-02
1 reads
It's just the way how ADO queries SQL Server. To find more about sp_cursor sp look at "System Stored Procedures" in Books-On-Line. There is a section on sp_cursor... Sps at the bottom of the article.
2003-05-28
Thanks so much! it's exactly what I needed (although without the "ALL" - to not have duplicates) It's those usefull T-SQL stuff that are so elusive sometimes. I should really slap myself for: a. not knowing this operator before b. for not reading the SELECT specification carefully enough I was already thinking to a level […]
2003-05-26
1 reads
Hi.. Please truncate the transaction log before shrinking the Logfile..check the below command to do it. dump tran Database_Name with no_log Now use the dbcc shrikfile command. levi
2003-05-26
Oops I could not understand your problem correctly. Is the 5.5GB file you are talking about is a database file?. If yes...check the Books Online for the command DBCC shrinkfile, shrinkdatabase and its usage..this might help you.
2003-05-26
A few questions: (1) What version of Lawson? (2) What version of Apps? (3) Lawson on same or separate box? On a related note, have you seen the Lawson SysAdmin group on Topica (http://www.topica.com)? You'll find me and few other Lawson SQL Server DBAs there as well... K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish […]
2003-05-12
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