Allen, thank you for bearing with me. I think I am being confused by the share. The share on the production server or remote server? Do the servers both need access to a share on the production server or the standby server, or both? The message says unable to send initialization file to secondary server, […]
2003-04-22
1 reads
Thanks for the replies. Let me elaborate a bit. The servers are on two different domains. When I go through the process, it appears I can browser the standby (remote) server. But, when the process begins, it gets that error above. Now, is this because the sqlserveragent on both boxes is started with different user/password. […]
2003-04-22
1 reads
Natalie, You have 8.00.679(SP2) from EM is because you have applied SQL Server hotfix MS02-061 for Slammer Virus. 8.00.534 (SP2) is real service pack you have. Apply hotfix seems it doesn't update table master.dbo.spt_server_info Edited by - Allen_Cui on 04/22/2003 12:41:39 PM
2003-04-22
1 reads
Correct the hardware shows an additional CPU per hyperthreading enabled CPU. If you are having issues you can usually turn hyperthreading off in the bios of your server until you upgrade your version of win2k and sql to use more than 4 cpus so SQL won't pick a virtual processor over a real one to […]
2003-04-22
Windows 2K and SQL 2K do not understand hyperthreadind. To them it looks like extra CPUs exist, and since Std has a 4 CPU limit, that is why you cannot hyperthread. We recently moved from a single here (at SQL Server Central.com) to a dual hyperthreading machine and it runs great, but it runs the […]
2003-04-22
Are there multiple cursors? Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-04-22
following are the details of linked server connection. security context remotelogin SA. Local login-sa remote login -sa
2003-04-22
2 reads
The linked server query is functioning well. The query gives error only used with xp_sendmail Edited by - jma100 on 04/22/2003 08:22:49 AM
2003-04-22
1 reads
Try this: create procedure [proc1] @cursor_name cursor varying output as declare @string nvarchar(1000) set @string = 'declare cursor_name cursor for select blah from foo ' + char(13) if len(@p_vcwhere) <> 0 set @string = @string + ' where ' + @p_vcWHERE exec sp_executesql @string This will return a cursor. Jeremy.
2003-04-22
The first step before you can begin log shipping is to ensure that the SQL Server login IDs are synchronized between the production and standby servers. This is important because SQL Server maintains separate security among servers, and you will be making a backup of a database on one server and restoring it to another. […]
2003-04-22
1 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
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