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 >>