Hi, I'm just starting to use SQL Server Developer Edition on my laptop. When I'm networked I sometimes need to copy databases onto my local SQL Server using DTS, which requires a networked account with local admin privelages on the local machine and remote machine; however, when I need to ...more >>

Is there a way to convert a datetime field to a smalldatetime field. I try to Update the filed with a cast or convert function it htrows an overflow exception, also changing the datatype via mmc is not possible. thx, Gerald. ...more >>

will a update trigger fire a insert and/or delete trigger?...more >>

will an update trigger fire an insert and/or delete trigger?...more >>

"meg" wrote: I've created the calendar table and inserted my holidays, however I just don't know how to implement the query. If anyone has any experience with this I would greatly appreciate it!! Thanks, meg "Alejandro Mesa" <AlejandroMesa@discussions.microsoft.comwrote in me...more >>

I used the Data Transformation Services Import Wizard to create SQL Server (SS) database and everything went weel up to a point. The tables were created and they were loaded with the data found on the Informix DB. What I also need are the parent-child relationships (primary/foreign keys) an...more >>

I have upgraded an NT 4.0 server to Win2k server. The NT 4.0 server had SQL Server 2000 on it. Once the upgrade was done and the server rebooted and SQL Server did not start on boot up. When I tried to manually start it I received an error saying Access Denied, clicked ok and received a SQL...more >>

I have upgraded an NT 4.0 server to Win2k server. The NT 4.0 server had SQL Server 2000 on it. Once the upgrade was done and the server rebooted and SQL Server did not start on boot up. When I tried to manually start it I received an error saying Access Denied, clicked ok and received a SQL...more >>

Hello, i've made an application with the vb.net and i created my connection through the sql server by stored procedure. The identity of the [ID] of the table that the data is stored in is on and i've entered some data as a trial. Then i've deleted the rows that i've entered and i made the id...more >>

I bought microsoft sql server 200 developer edition 64 bit. I try to install to my window 2000 xp professional,but can't install.The message always prompt that "setup.exe can run in win32 application",why like that?? How to solve this problem?Thanks. warmest regards, leong...more >>

Hi, I am having issues running SQL server 2000 on my XP box. after installation I am unable to gain access to the local server group. I get continual log in errors. I am unable to regisiter new servers. SQL server just wont start. I have installed and uninstalled a couple of times with di...more >>

Hi, I know that SQL Standard Edition would not let me install the Database Server in my machine. But will let me install only client components. the message I get is as follow: Microsoft SQL Server 2000 Standard Edition server component is not support on this operating system. Only client...more >>

who can help for this: install SQL2000 client on Win2k / Winxp, meet the folllowing error: setup cannot continute because some system files are out of date on your system, click OK if you would like setup to update these files for you now. You will need to restart Windows before you can ru...more >>

I have created a table called events with default Start and End Dates. I would like to modify the EndDate. Here's the table created. CREATE TABLE Events ( EventID int IDENTITY(1,1) NOT NULL, EventType nvarchar(10) NOT NULL Default 'Party', EventTitle nvarchar(100) NULL, EventDescript...more >>

Hi all, thanks in advance. Ok, heres the story. What is happening...... -------------------------------- I've got an ASP page that loops. It loops in order to get data in different, sequential date ranges. I.E. from 9/1/2000 - 10/1/2000 then 10/1/2000 - 11/1/2000 etc etc etc. It calls SPs...more >>

Hello I have several w2k3 ent servers running sql2k. They all replicate to a main server which is working great. What i would like to do is have the main server page me or email me when an error accurs with the replication. Is this possible? Thanks for any insight! -- TC ...more >>

Greetings, Our application is in VC++ and our business logic involves intensive calculations on huge amounts of data. For business reasons, we're forced to use MS SQL and not the obvious ODBMS. We were wondering if anyone would be in the same situation and if anyone chose to use an Ob...more >>

Hi I have a very large program which includes a facility which allows users to search for a client based on a number of parameters they select. This has worked perfectly with SQL Server 7 and MSDE until we upgraded to SQL Server 2000. Query analyser returns results when connected to SQL...more >>

I recently installed the SQL Server 2005 Beta2, along with Beta1 of VS.NET 2005. I am trying to create a database, and run quesries, but do not see any tools (enterprise manager, query analyser, etc) to do that in the SQL Server IDE . All I see is the Computer management console. I read a...more >>

I have a stored procedure written for number of updates, inserts to the database. This stored procedure takes too long to run. I have created few indexes around few tables, but the response time is not that defferent. THere is a Curser "CURSOR FAST_FORWARD FOR" in the stored procedure, and ...more >>

How can I setup SQL server to build a network of 3 computers using MS access project. One computer is the host and the other 2 are clients. Where to start. -- Nasser Takieldin...more >>

I have my server settings default to British English language or US English. Depending on the default language I select, date format should change when i run a query which selects a date column. Eg: British English - dd/mm/yyyy US English - mm/dd/yyyy How can I achieve this?...more >>

Hello, Could someone let me know how to log ship the database and the steps invloved in it? Can you create a scheduled plan for this or is it done only when it is in need? Thanks, Shyam...more >>

...more >>

Hello, In the past i had an enviroment W2K server and SQL Server 2000. Now, W2K3 server and SQL Server 2000. If i make a SQL server registration with an local IP address, i don't have problems, but if i try to register the same server with a NAT IP, it doesn't work. ...more >>

Hello! We are currently running Sql Server 7.0 with databases in 6.5-compatibility mode for DB-Library. The customer is starting to think about an upgrade of their systems. - Will db-library still be supported in Sql Server 2005? - If so, is the behaviour exactly the same as before or has ...more >>

Hello, I am looking for some tips to tune my SQL server. I have SQL 7 and 2000 running on NT and Win 2000 and things are slowing down on SQL servers. Both take many mins to return simple query output. I got some help in this NG before but that was more sort of creating index etc. It was ...more >>

I am running single instance of MSDE under Windows XP + SP1. The system has Intel P4 HT enabled processor with 512 MB RAM and 80 GB of Disk space. The MSDE has one database. My application adds one row in every 5 minutes into a table. There is no other application is running in that system. I...more >>

Oracle has specific storage parameters for tables like pctfree,pctused etc... how can this be taken care of in SQL Server 2000. ...more >>

The Query Internal Processor Architecture of SQL Server speaks of the reuse of Execution plan, the procedure cache, autoparametrization, the prepare/execute model..... So my question is Does SQL Server 2000 do caching by default or some parameters/flags are to be turned on to enable it?? ...more >>

when i run a query my sql server start taking lots of memory (4/5 of total on the server) and after the run it do not release that memory, means it starts slowing the system because of that. is that common or something else is going on ? ...more >>

Hi, Does anyone know of a good manual for Oracle DBA's to transition to SQL Server. There are so many questions I have regarding "How do you do that in SQL server?" ...like simple Oracle commands "desc <table_name>" or select all tables for certain users "select table_name from user_tables...more >>

Hello, how i can translate this sentence of oracle to sqlserver? SELECT sysdate FROM dual; Thanks....more >>

If I can physically add an additional processor to my SQL Server, is there any thing I need to bare in mind from a SQL server front - i.e. can this be done? do I have to change any SQL server settings to detect the second processor?...more >>

Hello, where i can obtain a list of functions of sqlserver? Thanks...more >>

we have sql server 2000 with lots of data with around 20 tables running and around 10 tables containing more than 1 million records on windows 2000 advance server. now the problem is that even a simple select query takes 5-10 mins to give result, forget about complex query that might take ...more >>

we have sql 7 with lots of data with around 200 tables running on windows nt. now the problem is that even a simple select query takes 10-30 mins to give result, forget about complex query that might take whole night to give result. i am sure there is solution for this problem, only i do not k...more >>

I'm running a SQL 2000 cluster that is attached to a local SAN. I would like to configure another SQL server (Server "C") to run using the internal storage. We have had several problems with our SAN and I would like to fire up Server "C" to handle the users when the SAN takes a hit. What sho...more >>

Can I modify the field length in a table that is in replication without breaking replication and rebuilding it?...more >>

Hello, how i can substitut a nvl function in sql sentence of oracle in Microsoft SqlServer? Thanks....more >>

I have SBS 2003 installed on one server (Box#1) and SQL Server 3a (Box#2) installed on another in teh same domain. IT seems when I am running MSDE for SBS Monitoring and Sharepoint Services on Box#1, Box#2 only uses one processor when for SQL activity. When I stop or remove MSDE from Box#1, ...more >>

Hello, In logshipping can i have two sources come to the same destination. like Machine A and Machine B (primary) have the same destination.Machine(D)...more >>

Let’s say that I have this application. It uses a database for its processing. There is another application, with its own database (same server), but some of its tables already exist in the previous application. What should I do? I could define a DTS package and copy the contents of the tab...more >>

this instance of SQL server has been using a process id of 1400 since...more >>

is it possible to run sql 2005 express on 2003 web-edition (legally)?? cheers, Alex...more >>

Can't find reporting services in SQL2000 enterprise edition. Your help...more >>

Hello, I have many scripts to run. I tried to call them of a manuscript (all.sql) which contains the name of each manuscript here is the contents of the file all.sql : :r scr1.sql :r scr2.sql I run this command : isql -S sss -d yyy -U xxxx -P mm -i all.sql -o out.txt but I obtain ...more >>

Does sqlmaint/DB maintainence plan have a provision for specifying more than 1 disk backup files for a database dump? This is important in my environment as my database is 4GB+ and growing at a fast rate....more >>

I'm looking for some good general information on administering MS-SQL 2000 databases. All the programming and database design are done by other companies (mainly off-the-shelf products), but ultimately if the database goes down - I'm the one in charge of fixing it. I'm looking for book rec...more >>

Hello. I have to run many sql scripts each day. Sometimes I'll have 100+ scripts to run. The scripts always come in a folder numbered in the order they need to be run (001 - ScriptA, 002 - ScriptB, etc.). I've been running them all manaully one by one so that I can look for errors in the re...more >>