what is the maximum number of concurrent logins MS SQL can support ? does it depend on the resources of the server ? assuming the server has almost unlimited resources, is there a max number of concurrent users that can log in?...more >>

I have three tables: Products Table PID PName PType Linking Table LID PID CID Customers Table CID CName CPhone I am trying to make a single statement that will give me all the customers that haven't bought a certain single product so i can make a list of people to c...more >>

Hello all - I have a database that I want to import into SQL Server 2000 - it has users with data/attributes associated with those users. I want to create those users in Active Directory and keep there data in SQL - At present, the users are only in the Database (in a users table) but I want to ...more >>

Hi All, part A: I have a thought and wanted to share it. Has anyone ever used Indexed Views created in Database A where all the underlying referenced objects are in Database B? Both Database A and B are on the same server. Database A is a Log Shipping Standby Server that has Logs applied to it ...more >>

A database goes "SUSPECT" the client deatach de DB. later it tries to reatach it but he gets an error. I tried to copy the file to other disk but I get an error from windows saying that a cyclic error in the disk prevent the copy. Is there any way to attach a file with problems? just in order...more >>

Red means error. Green means no error. OK? Lets try to make sure in = SQL Server that when something uses an icon we make sure we stick to = this User Design. It is erroneous User Design Fundamentals to have 99% = of icons show green for no error and 1% to show red as no error. IMHO. = Now...more >>

We have not done a lot of locking in our stored procedures up to this point, but have a requirement now that we need some help with. Sorry for the length of this post... Got an SP that gets a cursor of health claims from an "input" table that are still free for the taking. Multiple li...more >>

What are the description for the parameters 1204 and 3605 in the DBCC TRACEON(1204,3605,-1)? Thank You Mike ...more >>

Hello all, I'm having the following space allocation issue with a large table in a SQL Server 2000 DB. I have a table which stores visits to a site, currently with 95 million rows. This table currently has a total of 60GB space: 24GB used space, 4GB index space, and 32 GB unused space. T...more >>

mk:@MSITStore:G:\MSSQL7\BOOKS\SQLBOL.CHM::/html/r_model_16.htm Change the above to the drive yours is on. You should be able to just = click on this and bring up the page in Microsoft SQL Server 7.0. Notice in this there is no listing for an icon that looks like this: Is my SQL 7.0 we...more >>

I have a performance problem here I could really do with some help on. I am running SQL Server 7 on Win2k on a Dual Xeon box. I moved the database from a much older machine and had some initial problems running a particular complex query because of parallelism. Essentially, doing an sp_upda...more >>

I know I could do the following but forgotten what keywords I need to use to do it. Basically, i have a SQL Server 2000 table called store created by an SQL user called "publications". What do I need to set up for the windows user MachineName\IUSR_MachineName to run SELECT * from store as opp...more >>

Folks, Running the follwoing script I get the following error: Server: Msg 170, Level 15, State 1, Line 12 Line 12: Incorrect syntax near '@charDirPathSource'. Wondered if anybody could show me how to combine an SP variable in to an SP 'bulk insert' statement. Tia. Be sure to put prop...more >>

There are two tables table A & table B. There are two indexes defined on each of these tables. As I insert records into the tables (ODBC programming), I notice that occassionally the time required to insert the records is very high. Normally, the time required to insert records into the two ta...more >>

Hi, I have install the SQL Server 2k Eval version on a Win2K computer and update to SP3. the computer also running the IIS too. When I install the server tools of SQL Server 2000 CE Edition, I got the following error message:- "SQL Serve CE Server Tools is compatible only with SQL Server 20...more >>

I have a SQL database setup with 1 table that has 4 fields. messageID, Name, Date, Message messageID is filled in by SQL automatically (How do I get the Date to be filled in automatically?) The intranet is on IIS 6 with frontpage 2003 extentions. I would like a page that I can submit extra re...more >>

Hi, I just setup 2 different DTS packages for this... But is there a way to insert data from a view into two different tables with one transformation? ...more >>

I want to copy all objects and data from other SQL 2000 server std. to my local server(SQL 2000 personal) to test something. when I do copy wizard I got a message "SQL Server service is running under localsystem account. To get the privilege to copy through the network you should change SQL ...more >>

I would like to get events when delete,update,insert operations take place on certain tables. On my PC ( windows Server 2003), I seems to be missing all the SQL Server WMI stuff ( I can see that Biztalk, etc Any idea?...more >>

Hi, I have a backup of a database that is running every night from SQL 2000 server. I would like to be able to delete the backup and stop it from running. However, I cannot find it listed anywhere. How can I locate this scheduled backup so I can delete it. Thanks, Tim Heilman ...more >>

Hi, We have never worked on databases and are currently developing our vb.net windows application where we want to use some database to store data. Our application will be geared towards desktop users (single user using our app and saving data on his computer), a group of users (who share da...more >>

I have created a database (Test) on a sql server with a table (message) I have setup a system DSN to connect to this. I have then used access2003 to connect to the DSN (I assume!) Access2003 has no problem getting the data in the message table but I can't actually modify or add any records. C...more >>

Recently I added a varchar(8000) to a table through enterprise manager. Everything went fine, no errors/warnings reported. Thought I should script the change, got a warning through query analyzer that row exceeded 8060. That I understand just fine. Being no expert, I'm wondering how I can ch...more >>

Hello all - I have a LDAP service running on a NT4 box (not a mbr of my AD domain), I'd like to extract the users/attributes from that LDAP service and populate my AD domain with those users and attributes (the user accounts in LDAP will go into AD and the attributes for those users will go into ...more >>

Does anyone have any Step-by-Step guide to creating a SQL Cluster on Windows Server 2003? Any tips, gotchas etc? Thank you. ...more >>

I have posted this before but no response, please if anyone knows anything or is experiencing something similar, I need help! When running a basic select query in QA, then viewing the current activity - process info on EM, there are 20 - 148(highest so far) contextid's. Wait types are varying,...more >>

Hi. We've built a web based app with a sql backed and are looking to buy a new server with all the correct licenses. 1. Are resellers like http://ebargainsoftware.com/micsqllser.html legit? 2. Would sql 2000(3?) per processor lic, be the way to go? 3. Windows Server 2003 Standard Ed. What ...more >>

Hello all - I have a LDAP service running on a NT4 box (not a mbr of my AD domain), I'd like to extract the users/attributes from that LDAP service and populate my AD domain with those users and attributes (the user accounts in LDAP will go into AD and the attributes for those users will go into ...more >>

Hello!' New to the admin aspect of SQL 2000, wondering if there are any advantages/disadvantaged of backing the databases using the NT backup utility found in Windows 2000 server. Is there anything that should be excluded similar to,like, the M drive on Exchange 2000? Thanks ! Carl...more >>

Dear all, Our client is using Eng Win NT Server with SQL 6.5 & SP5a for Server and the client machine is using Trad Chinese Chinese. We found a problem. When the client insert getdate() into database, the month become Chinese character. However, we found that the SQL Server 6.5 is install...more >>

Is there away to increase the number of characters the line displays or writes out in the Message field within SQL Server Enterprise Manager 2000. It would be very helpful to resolve locking problems. Thank You, Dan ...more >>

My boss is asking me to do a Disaster recovery plan , I have to take the database file ,I.E rick.mdf from a sql 7 server a and place it on sql 7 server b they have the same service patch levels . My problem is i can't import in to the server b , It says not in microsoft tape format . Can you point m...more >>

I trying to use the BULK INSERT command to insert data into a table. The table has an insert trigger. The problem is that the trigger is fired only once for the whole bulk. The trigger is fired only for the last row inserted in the table. HELP???...more >>

Is it all right to install SQL Server 6.5 Client utilities on a Windows XP workstation? When I do the install, I get the message that 6.5 is not supported on XP, but I can still install the 6.5 client utilites all the same. The 6.5 tools seem to work fine on Windows XP. Does anyone know of anything ...more >>

Do I need to do a delete of the old value and insert the new? I would prefer to somehow do an update, if possible. ...more >>

our production SQL Server uses a NAS for storage. I'm not a Network or Hardware guy, but I've seen a few articles suggesting that a NAS is not the best option for SQL Server due to latency issues with network traffic (TCP\IP). We are having performance issues in Prod and I suspect that the N...more >>

Hello: When I export a table in comma delimited format, it works OK, but there is one problem. If the field is varchar (or char) and has the size, for instance, 50, there are empty spaces in the text file, so it looks like this: "CBAS ","Bass Gambling Supplies ...more >>

I just create a new DB under SQL 2000 and the Login Name is my network id How can i change this to be SA like it should be ...more >>

How do I truncate a huge transaction log file. Steps will be very helpful for I am new in this field. Books on line is very vague and not to the point. TIA Cicilia...more >>

how can i insert a default value for a datetime field, with something like the VB '=Now()' ? thx...more >>

My transaction log is filling up at an alarming rate on my production server. I have 2 log files with restricted file growth of 20gigs. This is all used up. I just added a 3rd log file with 2 gig and unrestricted file growth. I did a complete backup of the database in question which ha...more >>

When run UPDATE STATISTICS, you can specify FULLSCAN, SAMPLE number, or leave it blank. We have a table that when run UPDATE STATISTICS with FULLSCAN, it will take one hour long. If I just run UPDATE STATISTICS TableName without any argument supplied, it take 3 minutes to finish. It take 21 hour...more >>

Bare with me folks, I'm not a DB guy. I posted this over on Windows 2000, but hope you may have some clues for me over here. ----- I have a Windows 2000 GC server running SQL. The event log on this server is logging Event ID 11, source KDC every few hours. The details of the error are: ...more >>

The scenario is probably pretty common. There is a lot of new DTS package development work by a number of people at our location, and others. The target for installation is a production server located elsewhere. Everyone here has access to the production server, to look at data, perhaps make schem...more >>

Anyone knows of any good source of DBCC commands (not the usual ones .... the hindden commands), and TRACE flags? TIA Pablo...more >>

I create a VB ActiveX DLL custom task, when i execute the package containing the DLL custom task, all is ok But when i scheduled the package i receive the message "Error: -2147024770 The specified module could not be found" In the code of the VB custom task i use the sysdtssteplog table from MS...more >>

I am on SQLServer 2000 svc pack 3. I have a maintenance plan that backs up my databases each night at 9pm. The transaction logs are backed every three hours between 6AM and 6PM. I have the option on the transaction log backups set to remove files older than 12 hours. It is not working. Oddly en...more >>

This will be my first post in the forum since a long time ago sorry if this was asked before but ... what is your experience/recommendations about using Hyperthreading on SQL 2000 and Win 2003? Any thoughts? Thanks for your help, Pablo...more >>

i have a job configured to run a stored procedure. In turn, that stored procedure then calls another stored procedure which is using CDONTS to send an email. the job fails. if i run the stored procedure within query analyser it works fine. If i configure the job to call the send mail s...more >>

I have 2 temp tables in a storedproc (MSSQL2000 SP3) Here is the first one (example) CREATE TABLE #AllotmentLines ( AllotmentNumber INT, RoomTypeNumber INT, DateStamp CHAR (8) COLLATE DATABASE_DEFAULT NOT NULL, CurrentCount SMALLINT, Adults SMALLINT, Children1 SMA...more >>