Hi. In my system since 27th april every second appears in event\application three failed connection with sa. How can is possible ? On this server there are all my website. Can you help me ? Saimon(Florence) ...more >>

With a query such as, SET NoCount ON INSERT INTO .... VALUES ... SELECT scope_identity() SET NoCount OFF , can I trust that the id I get back is for the row that I just inserted, or can it be incorrect because of other "simultaneous" inserts? I need it for an ASP page. Thanks, Ma...more >>

Hi, here is the problem... I must create a store procedure that do the following... 1. select id_name,...'some other field' from table 'data' where 'criteria' = @parameter 2. use the result of the first selection to create another selection combining that results with the table 'name' whe...more >>

I've got a string of numbers, say 123456 (the actually number is 12 digits long). I need to calculate the sum of each individual number in the string of numbers, so in the example of 123456 the sum would be 21 (1+2+3+4+5+6). Thanks ...more >>

I have researched newsgroups and the web very thoroughly and unsuccessfully for a solution to what I believe is a very common problem. I know it's easy to do wildcard match against data in DB (using LIKE and "%" and "?"). But is it possible to match a concrete string against a database of wil...more >>

Hi! How can I get percent of executed procedure in MSSQL Server, lik in Enterprise Manager and/or dbMgr2k ? I use Visual C# and MSDE. Thank's for help, gregory...more >>

Hello All I was wondering if there's a way to monitor/measure data-transfer being taking place between 2 serves in a replicated environment. I cannot see any counters, etc. to monitor this..?? thanks Sunit...more >>

Hello I am trying to generate an email to be sent to an operator if a SQL Server (2000) goes down for any reason. I defined the alert to email operator for error number "17148" which is "SQL Server is terminating due to 'stop' request from Service Control Manager.". To test this, I shutdown ...more >>

Hello, I am putting together a row level security plan for our sales database. I will give a brief description of the method I am thinking of using to give you an idea of how I will need to be able to discover the group or login the user is using to access the data. I have a table called sa...more >>

Hi, i try get information about the online or offline status of a database within ms-sql srv 2000. I can look it up within server manager, but I'm looking for a way to get this information from the command line or a select statement. Is there a command or a sql statement that tells me t...more >>

I am getting above error, could pls anyone help me........? Soruce Code : Sub updateOfferCategoryAmounts(ByVal Transid As Long) Dim spComm As Command Set spComm = New Command Dim intCatID As Integer Dim rsBarADO As Recordset Dim spADO As Command Set s...more >>

When someone modifies a field in a table, I like to find out which field he/she changed. Currently, only the LAST person to modify an object is saved. For example, if I modify an Application record, I will see "MyName" in the "tblApplications.UpdatedBy" field and the date and time I updated it....more >>

Can anyone tell me if there's a way to create new windows from the tables section of a database in Enterprise Manager such that I can limit the tables included in that window? Ultimately, I'm looking for a solution whereby I can group tables, stored procedures, etc. into logical groups that can...more >>

Env : SLQSERVER2000 - DTS I want to import a text file with 3 fields in it ... F1: Ident char(3) F2: Note (Text) char(32,000) yeah big eh! F3: Date Field F2: has <CR><LF> thru it, this means the DTS import thinks its a multiple records to deal with as each row i...more >>

Scenario: 2 x win2k pro machines 1 x windows 2000 server In a workgroup not domain Problem: I have SQL2000 installed on my new server (SERVER001), I now need SQL Mail working. I have created a user account username: sql password: whatever and made it a member of the admin group. I...more >>

Hi I need to import data from StarOffice 5.2 spreadsheets to a Datawarehouse built in SQL Server and I wan to know what is the best way to do it. I think I have the next options: - Create a java app using StarOffice api - Use StarOffice Automation (I'm not shure if its possible in version 5...more >>

I perform full backup on MSSQL2000 However, the directory of backup files is only writable by Administrator But I find that I can't backup (I think it is due to permission) In which role MSSQL2000 is running? In Service->MSSQLSERVER It is set to Local System Account, Can I just change to A...more >>

I have written the following query and even though I used CAST if the number is less then 1 it show up as 0. Here is the query: select cast(count(SafetyTrainingYN) AS FLOAT) from ICPCDATA where SafetyTrainingYN = 1 / (select count(SafetyTrainingYN) from ICPCDATA) Any help would be much...more >>

Hi:) I need to dump data from database in to *.sql file. I try it using DUMP DATABASE but it not work that I need it. So, how can I dump data from database in to *.sql file and then run it using: osql -E -i nameOfDumpedDatabase.sql Thanks for help, greetings, gregory :)...more >>

Dear All, After copying a record using an Stored procedure all textfields (nvarchar) has max lenght ! See VBA-code and SP below VBA-code tos execute SP Dim objcommand As ADODB.Command Dim intReturnParam As Long Set objcommand = New ADODB.Command With objcommand ...more >>

Hi, Is it possible to create some SQL in VBA, 'run it' then view as a datasheet the results? I'm trying to throw together a fairly large search form, and VBA seems the best way to parse the parameters. Cheers, Chris ...more >>

I am trying to create a function in SQL 2000. Im rusty on function syntax and need to also assign some variables for use within this function. Example: create function blah (@param1 int) declare @var1 int, @var2 int --it doesnt like this method of assigning values to my variables???????...more >>

Hello, We are using Access Front End (ADP Project) and SQL Server 2000 backend. SQL Server is using NT Security. We do not want the users to access the the underlying tables. So, we went to each table and unchecked 'Select'. We also placed an 'X' in all columns for guest and public account....more >>

Hi, I want to find out what is a good way to identify indexes that need rebuilding. I tried to run DBCC showcontig and identify them based on the scan density %. And according to a Microsoft Tech Net - All About SQL Server Indexes discussion, the expert stated that based on the Density (below...more >>

Hello, I am investigating setting up a shared sql server. I wish to enforce database size quotas, and hopefully still allow customers to manage the creation of their own databases. Any thoughts or suggestions would be appreciated. Kind Regards Simon Hall...more >>

I am on windows xp, have installed sybase client, what driver do i need for tcp/ip connection to sybase12 sql server? For odbc, I only have Microsoft sql server driver Version 2000.81.9042.00...more >>

SELECT ISNUMERIC('. ') 1 SELECT CAST('. ' AS [insert any numeric type]) Syntax error converting the varchar value '. ' to a column of data type [insert any numeric type]. Any thoughts as to why SQL Server 7.0 considers '. ' to be numeric, yet can't convert it to any numeric data t...more >>

Hi, I wanted to know how can we send out email notification for the Jobs that are completed. Thanks a lot in advance.... AJ...more >>

After a recent crash, where tables had to be repaired we have been unable to re-instate or create new merge replication from a MS SQL 2000 system. All old publications and subscriptions have been deleted. New replications fail at the snapshot level. Anyone ideas ? *** Sent via Developersdex ht...more >>

I have two tables 1)Rollout_detail start_date Datetime, contract_date Datetime, budget_amt Money store_id int(foriegn key referring store.store_id) pan_number varchar(20) roll_id int 2)store store_id int(primary key) skey varchar(10) ...more >>

I have my Sql 2000 maintenance plan set to back up and then remove .bak and ..trn files after 4 days. It removes .bak fine, but not the .trn for some reason. This is ok for a while, but adventually it fills up the drive. I tried deleting and recreating the maint plan, but that didn't help. An...more >>

Hi Folks, I am using an xp_cmdshell sp to start a C# app. This app downloads data files and imports them into DB. It has a logging functionality built-in and when executed from the command line or WE, it records it's progress into a log TXT file. But when executed via xp_cmdshell, it doesn't ...more >>

Hi, I'm doing a proyect with Visual Basic where I have to use a database that I've already made on SQL SERVER. In my computer I had to install WINDOWS 2000 family server, to be able to install SQL SERVER as server not as a client, I can see perfectly and totally the database from VB. The prob...more >>

There appears to be a limit of ~16378 user Id's possible per database. When adding users we eventually get the message: > exec sp_adduser 'testUser', 'testUser', 'user_group' Server: Msg 15065, Level 16, State 1, Procedure sp_grantdbaccess, Line 160 All user IDs have been assigned. All of ...more >>

I'm having problems using the DB2 Connect ODBC Driver in my SQL Server 2000 DTS packages. It started occuring after installing MDAC 2.7 (which is necessary for the .NET framework). This error occurs when I try to open the transformation that uses an ODBC Connection object that is pointing to t...more >>

I Need help with accessing an SQL server from a web method. Trying to connect from localhost to ms sql server 2000 sp1 and get the error: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTran...more >>

Hello all, I have a scripts which needs the information about the database in which it is running. How can I find out this information. For example if I want to know the User who has satrted this report, I use the SYSTEM_USER procedure. Does an equal procedure exist to find out, on wh...more >>

Hi I am trying to design an IO subsystem for my SQL Server and for that I need to try and predict IO activity on each table in my MSSQL Database. My idea is to move the hottest tables into special disk subsystem away from the less hotter tables. So far I have gathered that we have three tabl...more >>

Hi, I'm a newbie with SQL Server 2000 Developer. I know that it is supposed to install on Windows XP Pro, but I keep running into the following message: "The logon account cannot be validated for the SQL Server service. Validate ...". I've looked for help and taken the advise of trying t...more >>

To anyone that is able to help.... What I am trying to do is this. I have two tables (Orders, and OrderDetails), and my question is on the order details. I would like to set up a stored procedure that essentially inserts in the orders table the mail order, and then insert multiple orderdetails...more >>

Hi, Quick question, I have about 20 users in my local server and database. We are looking to restore that database to a new server in a new network and still be able to retain the database users. We have created all 20 logins in the new server (exact names) but when we restore the database ...more >>

I have the following table with indexes CREATE TABLE dbo.Scratch ( ItemID int IDENTITY (1, 1) NOT NULL , Login varchar (12) NOT NULL , StartDate datetime NULL , PayDate datetime NULL , LastDisconnect datetime NULL ) GO CREATE INDEX idxPayDate ON dbo.Scratch(PayDate) GO ...more >>

I have an application which runs in many different stores. Stores that are within a chain want to be able to share their client lists. I want to implement a sync process where each application would ping a central server every 5-10 mins to check for changes made by any other store to the clien...more >>

--Table Create table tableName (Field1 int, Field2 int) Table Data Field1 Field2 1 10 2 10 3 10 1 20 2 20 3 30 I need Like a Sql statement like 1 10 (any separato...more >>

I am working with SQL 8.00. I have the following tables TABLE ClientInfo CheckNum Account Name Addr1 City State Zip --------------------------------------------------------------------- 12345 11111 John 123 Mary St Miami FL 33139 54321 22222 Mary ...more >>

Hi, How can i read information in Transaction Log in SQL Server 2000? Thanks...more >>

Can we make a Index on 2 or more tables Table a: Col1 int col2 varchar Table b: Col1 int col2 varchar can you have a single index for two tables a and b on the column Col1. Is this possible in SQL-Server. As far as i know you can make an index only on one Table....more >>

In an SQL statement which concatenates several fields I get a null value returned if any one of the fields are null. Is this to be expected? For example : SELECT tblMember.memberAddress + ' ' + tblMember.memberTown + ' ' + tblMember.memberCounty + ' ' + tblMember.memberPostCode + '<br> '...more >>

This is probably a common problem with a standard design pattern, but I'm having trouble finding the solution. I have a table with a lot of columns, for this example I'll just use three but in reality its more like 20. Create Table myTable (int col_one primary key, int col_two, varchar(20) ...more >>

When I add a unique key constraint to column in SQL 6.5 why does it also create an index. e.g. In the table subaccounts I added a unique key constraint for the column login and SQL creates an index with the name UQ_SubAccounts_2__19 (UKC). Does this also mean that there is no need to create a...more >>