I'm looking for an easy way to copy triggers from my development database to my production database without having to copy and paste the trigger to each table. ...more >>

Anyone know how to enumerate the SQL Servers on a network using .Net? I can do this with VB6, but howso in .Net? ...more >>

What is the maximum amount of memory that sql server standard 2000 can use and what is the best way to configure sql server to use this amount of memory? ...more >>

If I do a default SQL Server installation, and then find that I'd like to have several instances installed after all, will I be stuck? Thanks, - Joe Geretz - ...more >>

We recommend that our clients install SQL Server at each of their satellite offices. Every night we DTS the central database out to the satellite offices. That way, if the link goes down, or if the main server were to go down, we'd have one or more backup databases to switch over to. One clien...more >>

Do any one know how to create a mapping drive. I am using SQL Server standard edition version 7 but Network attached storage for this version are disable. So how to enable it? and how to create a map drive for backup database to another network drive? your co-orperation will be appreciate...more >>

Description: I have a database, named 'quiz', with a table named 'play' in it. column name type indexno int pos int deleted int freq int There are 5 records: indexno pos deleted freq 1 11 null null 2 11 nul...more >>

Hi, I have SQL 2000 server sp3 on W2K server. The SQL utilities are on C drive and the database is on D drive. I need to replace the current hard drive D with a bigger one as it's running out of space. I'm looking for the best way to do that. If I replace the current one with the new blank D ...more >>

Hi... any body knows what is the limit of rows than can be managed by an index in SQL 7? ...more >>

I have two databases that I have created this query for: SELECT CT_CRPCD.ACTIVE AS ct_crpcdActive, CT_CRPCD.CASENUM AS CaseNumber, CT_CRPCD.BOOK AS Book, CT_CRPCD.PAGE AS Page, Common.dbo.CT_IMAGE.FILENAME AS [File Name] FROM CT_CRPCD INNER JOIN Common.dbo.CT_IMAGE ON CT...more >>

Hi all, I am looking for a logical answer to question of overall database design. I am NOT a sql server expert. Here are some assumptions: 1) I have a web application that I host and it uses sql server as the database 2) There will be many different companies (Somewhere between 50 and...more >>

I generated a script by right clicking on the job tree in Enterprise Manager. I then tried to run the script to create the job on another server and got the following error. Please advise. Server: Msg 515, Level 16, State 2, Procedure sp_add_job, Line 105 Cannot insert the value NULL i...more >>

Why do my asp forms stop submitting data into my SQL Server 2000 Database when I insert a trigger to send email on Insert or Delete? I can still add entries manually to the database and SQL successfully send the email out when the table is updated. Once I put the trigger in place though my web bas...more >>

Is there a forum dedicated to this application or am I to post my run-time error question here? Thanks ALL....more >>

At the outset I apologize for this question, if it looks inappropriate here. There is a debate going on in oracle newsgroup about which database Microsoft is using for its internal implementation of SAP at their HeadQuarters. Per them it is Oracle, even though this one mentions it as SQLServer...more >>

Hi, I have a database size of 2,5 Gb, and I set the transaction log unrestricted growth. I backup the database every nite, and next morning the transaction log goes up to 4 Gb!. If I restrict the log file (to 800Mb) it will get full within a couple of hours. If I manually backup the log file an...more >>

sql server 2k... I found the Set DateFormat method but I can't seem to find a get method where it will return to me what sqlserver is set as...(mdy,dmy etc..) does such a method/property exist? thanks Doug -- Doug Swanson Senior Applications Developer Synchrono, Inc 651.228.1772 dsw...more >>

Hi all, I need a boolean field like yes/no in MS Access. Isn't there such a data type in SQL Server? What should I do ? TIA, CSharp ...more >>

Hi all, I need an autonumber field in a table. I set the following parameters for the field: data type - int, identity - yes (not for replication) identity seed - 1 identity increment - 1 Is this the right thing to do? TIA CSharp ...more >>

Hi Fairly new to SQL so apologies if this is really dumb. Can anyone see what is wrong with the relationship here (http://www.step-online.org.uk/Diagram.png) I two many-to-many relationships which I have tried to make a many-to-many-to-many relationship out of! I have Individuals and C...more >>

Hi: I am starting to rip my hair out. I pretty much tried everything. I want to insert following values: sqlString = "INSERT into myTable (ProductID, Name, Title, CategoryID, Organization, Address, City, State, Zip, Country, Phone, Fax, Email, Heard, Referral, Computer, Implement, Descr...more >>

Scenario: Just connected a 2000 server running SQL 2000 to an Iomega NAS via a crossover. Set both machines to be in the same workgroup and both have the same local admin user and password. Also set the SQL service and the agent service to run as the local admin. Setup the NAS box to shar...more >>

Good Afternoon, Does anybody knows how to decrypt store procedures?. I really appreciate your help. Frank *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi, I'm doing this insert (1 million records) across 2 database. and then the log file grows up to 1.7 GIG ! I truncate it and it stays this big. begin transaction go insert into olympicarchive.dbo.PrdToBuySaved select * from olympicprod.dbo.PrdToBuy where PTB_DateExpected <= '20...more >>

Hi I'm running a cursor (I know not quit good...but). For I don't know why, in one night the execution time step from 1h30 to 3h. I restore my database on a TEST Server (same version), the the execution time is still 1h30... I monitored both execution, and realise that the CPU time for the CXP...more >>

I am in the process of consolidating 3 of our OLTP databases onto one server using named instances. This box will be used exclusively for SQL server data, the apps will be on an application box. What I'm looking for is suggesations that make a significant difference in speed as far as disk se...more >>

Hi, Looking at purchasing SQL Server 2000, so I've downloaded the evaluation edition for the time being. Although I think I know the answer to this I'll ask anyway. We plan to use sql server as the database back end for an ASP application, now as asp is server side do I still need to purchas...more >>

For some reason when my tempdb log gets full, it does not truncate unless I restart services. Any ideas?...more >>

I am trying to switch an application from SYBASE ASE12.5.1 to MSSQL 2000. The application is a JAVA App running through TOMCAT. I have the JDBC drivers installed and they are working correctly, since I can log in to the app (which required DB access). I can also navigate through the app. When ...more >>

Hi, Yesterday I changed a motherboard on my SQL server 7.0. Today I noticed that jobs has not been started last night, and I noticed that date is wrong on this machine,so I did set the date and time and rebooted the machine, however still can not see the next run date on scheduled job, even...more >>

I have an application that connects to my database and stores in my database ICONS. The application is using the data type SQL_VARIANT. Was wondering, is sql_variant "ok" to use.... is there anything better... how about pointers? Can anyone give me some advice on this... Thanxs...more >>

How can I export all the tables in a given database, without the data.. to later import them elsewhere, with MSSQL7. Preferably, without having to use the Enterprise Manager -- but even that would be fine. Thanks...more >>

Pls help. We still have sql server 6.5. I was trying to register server with the same version however an error was encountered. The error is "Unable to connect: Sql server is unavailable or does not exists. OS error 1326 - ConnectionOpen(CreateFile())". Does anyone know how to resolve th...more >>

I have recently had a drive failure (1 of 5 in a RAID 5 config). Along with the drive failure, removing the faulty drive resulted in a registry failure (Windows 200 Server SP4). So after pulling my hair out all day I, finally restore the registry file, and get back up with 4 of 5 drives running wi...more >>

Hi, Could anyone let me know how to automate the sql job scripting? regards, bharath...more >>

Hi I have developed a SQL Server database that holds spatial data (polygons, points and lines). However, as there are no spatial data types in SQL Server 7, spatial queries and spatial joins are very inefficient. Does anyone know if SQL Server supports spatial data types - is there an addon t...more >>

hi i hope someone can help me please, i have sql server 2000 installed on SBS2003, i have the client toools of sql server 2000 installed on my local machine. i am working on web developement, and am using IIS6.0 which im really struggling with problem 1. When try to connect to the database via...more >>

our mastlog.ldf file of Master database got deleted accidently by some user. Is there anyway that the database could be started and new log file created. master.mdf file is intact Thank AT...more >>

Hi All, I am getting the following error when I execute the following BCP command from query analyser BCP Comman ======== xp_cmdshell 'c:\MSSQL7\BINN\BCP SQLManager.dbo.z_DBAdmin_Fwd_MAXDRBUS02_DBAdmin_dbo_tbl_CheckServerRoleMembers_20040331161058 in "c:\Temp\DBAdmin_Fwd_MAXDRBUS02_DBAdmin_tbl...more >>

I have SQL Server 2000 (SP3) on the Windows Server 2000 (SP4). I received next message in the Event Log Source: MSSQLSERVE Category: (2 ID: 1705 1805 Error: 3624, Severity: 20, State: What's is a problem Michael S. Androso EXPOCENT ...more >>

I'm a VB6 / MS Access programmer trying to get up to speed in the world of ASP.NET and SQL Server 2000. I'm on a fairly large web database project so I'm trying to use VisualUML for management of the database schema. I expect many generations of design as the requirements become defined in an i...more >>

Curious to know if i stop the SQL agent service, will the jobs that are currently running, terminate or continue to run ...? Using SQL 2000 ...more >>

CREATE Procedure GetSingleUser ( @Email nvarchar(100), @Password nvarchar(20), @UserID int OUTPUT, @appId int OUTPUT, @lastPage nvarchar(20) OUTPUT ) AS DECLARE @c INTEGER DECLARE @d INTEGER SELECT @UserID=UserID, @lastPage=lastPage FROM UserInfo INNER JOIN App ON ...more >>

Sql6.5 Are there any problems adding a "NEW" field to a table while table still active but not in use ? This field will be at aded to the end of the field list. I don't think there should be any problem but not certain under 6.5 ...more >>

I have declare a table variable named @Results to store some temporary data. When I try to retrieve data from it, I get the @Results must be declare error. Can anyone one please help Declare @Filters As VARCHAR(500 DECLARE @SQL VARCHAR(2000 SET @Filters = ' Tag LIKE ''Hello'' SET @SQL = 'Selec...more >>

Hi I would like to pass a stream of varchar as my "where" clause as follow Select * from test where + @Filter I can't get this work until I declare the SQL as varchar and then execute the query as follow DECLARE @SQL VARCHAR(2000 SET @SQL = 'Select * from test where ' + @Filters EXEC (@...more >>

I get these messages in the SQL Server logs numerous times per day following a SQL Server memory dump. 2004-03-20 01:40:31.51 spid78 Using 'dbghelp.dll' version '4.0.5' *Dump thread - spid = 78, PSS = 0x668176a8, EC = 0x668179d8 *Stack Dump being sent to d:\MSSQL\log\SQLDump0105.txt * ...more >>

Hi, What is the maximum size of a table?? Is it restrict to growing of database file(.MDF)?? If not, where can configure to increase the size of a table related to the number of registers? I look for something on help, but I only found something about Data Base File growing. Regards, -- ...more >>

Does anyone know if the ANSI-92 Except(ALL) Operator will be included in YUKON? This is similar to Oracle's MINUS function Thx...more >>

Hello everyone, I am building a cube that contains a single date dimension. The problem is, the business I am building this cube for has a fiscal year that starts on November 1. When I create the date dimension, I am prompted for the start date of the year. If I select the default va...more >>