Viewing 15 posts - 121 through 135 (of 1,165 total)
Try the following...
declare @sciid int
select @sciid = 0
while 1 = 1
begin
update city top (1) sciid = @sciid + 1 where sciid is null
if @@rowcount = 0 break
select @sciid + 1
end
March 24, 2007 at 10:29 am
You can write the header information to a different txt file then you can merge both txt file into one...
I beleive merging is simple...
March 22, 2007 at 12:08 am
I don't think there is any fix within the sql...
But how it got half of the original image...sql will not shrink then who did?
March 22, 2007 at 12:06 am
If there is an option I will prefer tempdb with raid 10 and see the reason to create more than 1 file in the following article...
http://support.microsoft.com/kb/328551
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/tempdb_capacity_planning_index.mspx
http://blogs.msdn.com/sqlcat/archive/2005/11/21/495440.aspx
March 22, 2007 at 12:00 am
If you want to copy the data from one database to another database on the same server you don't need to use dts package...
It can be done using TSQL...
Insert into...
March 21, 2007 at 11:10 pm
I don't think you use local variables in the view...
March 21, 2007 at 11:03 pm
1. Move Dev2 login to 2005 server using sp_help_revlogin.
2. Backup the sql 2000 user database and restore on to sql 2005.
Or
Dettach the database manually using sp_dettachdb command and copy the...
March 21, 2007 at 10:56 pm
If it is inplace upgrade you upgrade distributor first then publisher and susbcriber...
If you are doing side by side upgrade it is better to create replication script in sql 2000...
March 21, 2007 at 7:29 pm
Did you confguration sql agent mail?
You need to enable mail profile in sql agent properties...
March 21, 2007 at 5:56 pm
Make sure there is no access issue...
Looks like your SSMS got corrupted...Try unistall and resintalling work station componenst on the laptop...
March update means SP2 hotfix? I think that hotfix is...
March 21, 2007 at 11:56 am
I don't think there is any issue with coexistance of sql server 2000 and 2005...
March 20, 2007 at 4:36 pm
Job status available in msdb..sysjobhistory table but I don't think SUSPENDED status exists...
You see the SUSPENDED status in sysprocesses table...
If the job status is in progress find the SPID of...
March 20, 2007 at 4:32 pm
Try
CREATE DATABASE FOR ATTACH_REBUILD_LOG option...
See BOL for details...
http://msdn2.microsoft.com/en-us/library/ms176061.aspx
March 19, 2007 at 2:01 pm
Viewing 15 posts - 121 through 135 (of 1,165 total)