Can any one tell me like if the table is not normalized and if there is no relationtionship in the database then what would be the impact on log shipping like it will generate extra log. Can any one let me know the disadvantages. Thanks John ...more >>

Can any one let me know which tool we have to use for database synchronization. The database is on different servers. Thanks NOOR ...more >>

Hi I have c# application that uses SQL SERVER databases. The problem is that after I close all connections to a database in order to make actions (detach, copy or delete) on the current database I get a message saying that the database still has connections. At the Enterprise man...more >>

Hello there, I am experiencing performance problems with an aplication running over a SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM memory. When there are just on or two users working, the aplication performance is suportable, but when more users are using the...more >>

How can we change the login userid by SQL Server Enterprise Manager. I login with my Windows userid but the last time I used a SQL Server account it still uses that account when start SQL Server Enterprise Manager. How do I change Enterpise Manager to use my windows userid. Thanks, ...more >>

I wanna check the linked server is exist then do nothing and if not then create linked server. Any command ? like if not exists() begin EXEC sp_addlinkedserver 'FASAT\FASATBASE' EXEC sp_addlinkedsrvlogin 'FASAT\FASATBASE', 'false', NULL, 'sa', 'testing' end Thanks Davi...more >>

Microsoft SQL Server 2000 SP4 is open for Public Beta Testing Sign up to test drive the newest service pack for SQL Server 2000 give us your feedback. SQL Server 2000 SP4 is now open for public beta testing. Instructions on how to signup for this beta program are below. SQL Server ...more >>

I have few questions? 1. Can I implement log shipping into two systems which has a SQL Server Enterprise Manager. 2. We can installed monitoring server on the standby or have to need the separate server. Thanks David...more >>

Hi, I want to connect my win-XP client with win-server-2003 SQL Server. I had done following task- - I had installed SQL-2000 (Ent. Edition) on Win-Server 2003. And it is successfully installed. - In Win-S-2003 with the help of Active Directory I created domain and created user on it. - C...more >>

Dear Professional, I am facing one problem regarding the Log shipping issues. Like I have created log shipping into two different server. One system called as a Production Server and the Second server called as a Standby Server. The production server backup the log file correctly but when we s...more >>

Can any one let me know the shortest possible like how I can inactive and active log shipping. The logshopping is working fine but want to inactive for two days and will active after that according to business need so can anyone let me know how is it possible. Thanks John. ...more >>

In logshipping DDL could be transfer to standby server or not. Like I have created one table after configuration the Logshipping so would that table would be transfer in the standby server or not or I have to create manually in the standby server. Thanks NOOR ...more >>

Is it possible to add a new user (with Windows authentication) for a user within a Windows workgroup rather than a Domain? On Workgroup (peer-to-peer) networks I get "Windows NT user or group 'Workgroup\user' not found. Check the name again." from sp_grantlogin - the same if I use MachineName\...more >>

Can any one let me know what Important factor have to consider while doing log shipping... plz guide me step by step... Thanks alot John ...more >>

Hi, I am asking a generic question about SQL server (or any type server communication for that matter) and how one would keep the connection open for the life time of the application, or should one close the connection for each request (or set of related requests)? Does SharePoint open / cl...more >>

Hi, After installing XP SP2 security patches on my box, I can not open Enterprise Manager. It crashes when I click on icon to bring the analyzer up. I get two error in event log, ======================== 1. Event Type: Error Event Source: Application Error Event Category: None Event ID...more >>

Hello, Is there a simple answer to this simple question? How to import fixed-width text file? I know the width of the columns but there are so many that I don't want redefine them. I have already a table build for that data with the necessary fields width. In dbase it was such a simple ...more >>

I want to use Sql Server Reporting service but I need the front end so can any one tell me is there any evaluation version of .Net so I can download from the net easily and use the reporting service of Sql Server 2000. Thanks Noor ...more >>

Dear Professional Can any one tell me about the constraint Priority like which run first and then second and so on. 1. Not Null 2. Primary key 3. Check 4. Foreign Key 5. Trigger 6. Default 7. Unique Thanks NOOR ...more >>

I'm looking at creating an association between a database and the hardware that it is running on - for example by creating a license key that includes a hash of the mac address. Obviously clients will be able to query the database directly. What I'm trying to do is to tie my client applicat...more >>

Can any let me know how can I do stored procedure version control Thanks NOOR ...more >>

PLEASE HELP! I have a large query that takes about a minute to run from the SQL Query Analyzer. Now when I run the query from VB6 it craps out 30 seconds into it. Is there a way around this without manipulating my query. I'm attaching the query maybe you'll see something I can adjust i'm no...more >>

Hopefully somebody see the mistake I am doing. We are using an Vb application connecting to SQL 7. After moving to SQL 2000 and Windows 2000 system the same application send error message when trying to insert or update any data via the VB application. What did I missied to transfer? I try t...more >>

Hi, I've posted this question in the asp.net newsgroup and it was suggested that my problem is more SQL Server-related than .NET, so I'm asking here as well. I have an asp.net web application that is intermitantly throwing Thread was being aborted errors in my data access component. I would ha...more >>

Is there any way through which we can read any file which exist in harddisk like c:\File.txt, I want to read that file via Sql Server. Basically I want to read xml file from the hard disk like c:\file1.xml. I am making one project and the project instructions is to first generate xml and sa...more >>

I am attempting to connect to a named instance of SS 2000 across the Internet using Enterprise Manager. The machine running SS is behind a NAT router. According to BOL I should be able to connect if I forward the TCP port that SS is using (1061 in my case) and UDP port 1434 to the SS machine...more >>

I am a beginner with MSSQL7 so please bear with me. I am trying to open a database that is approx 187KB in size. This file resides in the following folder; C:\MSSQL7\DATA. This was restored from a backup we reterived from a subjects computer. I obtained a copy of the MSSQL7 software. I wa...more >>

Can any one let me know is there any version of Sql Server available on the net to download for practising purpose. thanks NOOR ...more >>

Hi, I installed SQL Server 2000 personal edition on my Win XP sp2. In the enterprise manager, I can manage my local database, but if I try to connect via the Query analyzer, it says it cannot find the server or the access is denied. I added localhost in the Client network utilities and ...more >>

Dear Professional.... Can you plz tell me one thing like I have one XML file which is already saved in C:\File1.xml path. I want to parse that File1.xml file and save it into database through any stored procedure or any command but the problem is that how can I call the file File1.xml fr...more >>

I have used the following command but it output the result with spaces and number of records like 3 records effected. I don't want the spaces as well as number of records founds, what I have to do for eliminating those spaces and effected records. Exec master..xp_cmdshell 'OSQL -S"SERVER" ...more >>

When i run the SQLDATAadapter it cannot find the SQL server 2000. the error it gives is: Provider Cannnot be found. It may not be properly installed. I am running out of Ideas any help will nice? Thanks Tom...more >>

Hi, When ever I start the Enterprise manger client from my laptop(Client), I see the Failure Audit in the Security Eventlog. I registered all the servers using sql authentication. I am running SQL Enterprisemanger on Windows Xp. Here is one of the error: Unprotection of auditable protected da...more >>

Hi, Scenario is; while developing a Web Application based on ASP.NET/C# and SQL Server 2K, usually we need to have a complex processing which requires multiple looping operations apart from math calculations! So which is the best approach to encapsulate the Logic in? 1. C# Class which gets ...more >>

Hi, I am new to SQL Server. I use to work with Oracle and I have used tools like SQL*plus, SQL Navigator, etc. When I execute a long script with these tools, They generate an output containing each command followed by its result and error messages, like the example below. When I execute a lo...more >>

I've come across a Transact-SQL statement as follows: -- Statements start here select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from sysobjects where type = 'U' -- end here Questions: (1) How should the 'select' statement be interpreted? (2) What are the rules for u...more >>

Hello Professional, Can any one let me know that is it possible that I have to convert data into XML file. let's assume there is a customer table. I want to save that data into xml file and save it into c:\File1.xml ... is it possible... Waiting for your reply Noor ...more >>

I am about to attempt to configure a SQL server 7.0 client on a windows XP workstation. Does anyone have any suggestions or advice that will make this install go smoothly? I am not sure what will happen, but any advice would be helpful. Edward Letendre ...more >>

Hi all. I've been working with SQL server for a few years now, but I've never needed to solve this specific problem before, and I'm a little stuck Perhaps someone here can help me I have a user who needs to use Enterprise Manager tool, but I only want him to have control over a single DB, a...more >>