Search results for query: *

Greetings... I have two SQL 2000 servers, A and B, being Svr A in our local domain, and Svr B is in a DMZ (i.e. in the internet). Svr A can see Svr B, but for security reasons, Svr B cannot see Svr A. This is OK. From Svr A, I'm trying to make a distributed (remote) UPDATE being the source...

This is my scenario... Server A Server B Server C (SQL Svr 7) (SQL Svr 7) (SQL Svr 2000) (NT4 Svr) (NT4 Svr) (W2K Svr) Server A is outside a firewall. Server B and C are inside our company's W2K domain. Server B has Server A and C as linked servers. Server C...

This is my scenario... Server A Server B Server C (SQL Svr 7) (SQL Svr 7) (SQL Svr 2000) (NT4 Svr) (NT4 Svr) (W2K Svr) Server A is outside a firewall. Server B and C are inside our company's W2K domain. Server B has Server A and C as linked servers. Server C...

Greetings. When replicating (in 7.0), after I define a published article (in a table) and configure a suscription to that article, is there a way in which the customized stored procedures could be modified to accept NEW columns that are added into that table? I'm using transactional...

Greetings. According to what is configured on the publications, the system blocks after X minutes (10 by default) of inactivity have passed. This implies that the Agents and Publishers stop, the replication jobs bomb and there's no way to make them to start again. When this type of block...

My scenario is the following: (SQL Svr 7.0) I have a table that contains (among others) a column "MyColumn" that up to now it has been defined as NULL due to business rules. So, although this column can indeed allow null values, however I would like to create a UNIQUE constraint to...

This is my scenario: I got two SQL Server 7 servers (let's name them A and B). The firewall has been defined so that server A can't see server B (for data security reasons); however, server B can see server A. The replication has been configured in such a way that server A is the publisher...

Greetings. I'm using SQL Server 7. When I go through the "Configure Publisher and Distribution Wizard", when I press "Next" in the first screen, I get the already famous message: "SQL Server Enterprise Mgr could not complete the wizard because @@SERVERNAME for '' is...

Greetings. My situation is as follows: Whenever I want to create a new database (I'm using SQL Svr 7), although the default initial size is 1 MB, when I press OK I get an error message indicating that the initial size should be at least 81 MB. This is due to the fact that for a reason that I...

I know there's some sort of stored procedure to increase the number of locks but I can't find it (MSSQL 7.0) Can somebody give me a hand? Thanks.

Greetings... Could anyone advise me on how to remove permanently a nasty sql.log which is generated in my C drive and increases in size when I navigate by either the Enterprise Manager and/or Query Analyzer? I'm using NT 4.0 WS, thus I got a C: and D: drives partitioned in my PC. I installed...

Greetings. From "Server1" I try to perform a distributed UPDATE to a table in "Server2" UPDATE Server2.dBase2.dbo.Table2 SET Field2 = 'Blabla' WHERE AnotherBlablabla and get this error: Server: Msg 7306, Level 16, State 2, Line 1 Could not open table...

Scenario: Two SQL Servers - one being 7.0 and the other 6.5 Problem: The 7.0 cannot see the 6.5 by either a distributed query or browsing in the Enterprise Manager. The only way I could see data in the 6.5 is by making a direct connectivity with the Query Analyzer, but this won't be so useful...

Hola! I was debugging an already existing DTS using the package designer. When I was checking the sql server connectivity icon, I found that the user's password was incorrect, so of course I changed it. When I pressed OK to record the change, I answered "NO" (as I normally do to...

Greetings! Lately I've been finding that when I perform certain database backups to file, they're bombing with an Error = 112. I've been checking in my books and Books Online, but haven't found anything. Could somebody help? Thanx! J.C.

Greetings. Besides using triggers, is there a way to monitor which user inserted a new record in a table? Please advise. J.C.

Is there a way I could put the statement BEGIN DISTRIBUTED TRAN to work among two servers? I already checked that the MSDTC service is running and from my local server I can see the remote server as a linked server. Please advise. J.C.

I have two databases in the same SQL Server 7.0. To keep data integrity among tables, I would like to link a table from one with a table of the other using FKs/PKs. I know I can't do this by the use of Diagrams, and also tried manually by attempting an ALTER TABLE using the Query Analyzer... it...