I turned the Audit ALL option on SQLServer instance "security" tab and restarted the SQLServer but do not see any information logged in SQLServer Logs though I tried to access databases and logged in a couple of times through Query Analyzer. Why is that no logging happened and how can I get this fixed?
Any help is appreciated.
Vinnie
Hi,
iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Now iam devloping a Window Appplication in which I need to populate a grid from Sqlserver2000 (dev edition) which installed on remote (i.e another network)....when i try to run my application it gives me a error tht "Unable to connect to sqlserver2005".actaully i specified in my connection string to connect to Sqlserver2000 on the remote machine.
I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine
With regards
Mahender
I have made a server security audit and specify from database audit specification to audit "select" on a certain user and on a certain table. I logged in by this user and made the select statement..when i run this query
"select * from sys.fn_get_audit_file('d:Auditaudit1*',null,null)"
It return a value at which time the query has done
after 15 minutes i repeated the same action, i run the audit query and the same result is showed off on the panel.is it suppose to return a list of values by how many times this user has made the select statement on that table ? for example at 5:00 pm then 6:00 pm and so on
I need help...here is the problem.Last weekend, the servers in our datacenter where moved around. After thismove, and maybe coincidental, 1 server is performing very poor. Afterrunning a trace with SQL Profiler, I saw the problem which was laterconfirmed with another tool for SQL server performance monitoring. It seemsthat all connections to the SQL server (between 200 - 400) are doing a login/ logout for each command that they process. For example, the user'sconnection will login, perform a SELECT, and then logout. This is not a..NET application. The client software was not changed, it is still thesame. The vendor has said that it is not supposed to do that, it issupposed to use 1 connection that log's on in the morning and logs off atthe end of the day or whenever the user exits. 1 user may have severalconnections to the database.At times, the server is processing over 250 login / logouts (avgeraged for30 second period). Has anyone seen this problem? I have the server inAUDIT FAILUREs only. The server has become very unresponsive, things thattook 3 seconds now take over 15 seconds.Any ideas???
View 6 Replies View RelatedHi, I have a little question regarding
SQLServer2000 vs ADO of Visual Basic 6
In a code snipplet a have something like:
Conn1.BeginTrans
Set rec_tmp = Conn1.Execute("SELECT * FROM IDENTIFICATIONS;")
Conn1.Execute "DELETE FROM CARS WHERE CAR_ID = 8;"
.
.
.
Conn1.CommitTrans
and whe VB tries to execute the line with the
DELETE sentence the Err object says something like:
"cannot create a new connection because you are in
distributed or manual transaction mode"
However, if I remove the line that executes the sentence
SELECT * FROM IDENTIFICATIONS the error never shows up.
Seems like I canīt execute a SELECT before a DELETE/UPDATE
even if I execute the SELECT in some other table.
Iīve tried changing the IsolationLevel, Mode and Cursor
Location properties and the error always occurs.
Furthermore, I tried putting the SELECT out of the
transaction and the error continues showing up.
Why does this occurs? Is there a way to solve it?
NOTE: I need forcely to execute that SELECT before the DELETE.
Thanks for the time
Roland
Hi, I have a little question regarding
SQLServer2000 vs ADO of Visual Basic 6
In a code snipplet a have something like:
Conn1.BeginTrans
Set rec_tmp = Conn1.Execute("SELECT * FROM IDENTIFICATIONS;")
Conn1.Execute "DELETE FROM CARS WHERE CAR_ID = 8;"
.
.
.
Conn1.CommitTrans
and whe VB tries to execute the line with the
DELETE sentence the Err object says something like:
"cannot create a new connection because you are in
distributed or manual transaction mode"
However, if I remove the line that executes the sentence
SELECT * FROM IDENTIFICATIONS the error never shows up.
Seems like I canīt execute a SELECT before a DELETE/UPDATE
even if I execute the SELECT in some other table.
Iīve tried changing the IsolationLevel, Mode and Cursor
Location properties and the error always occurs.
Furthermore, I tried putting the SELECT out of the
transaction and the error continues showing up.
Why does this occurs? Is there a way to solve it?
NOTE: I need forcely to execute that SELECT before the DELETE.
Thanks for the time
Roland
date(m/dd/yyyy)9/18/2006 In this above table i want to select only the month in this format Sep 2006 . How to do that ?
View 1 Replies View RelatedHello everyone,My project (asp.net and sqlserver2000) is working fine in my intranet. But sometime, it cannot connect to sqlserver, it shows "SQLServer does not exists or access denied". If I restart my dbserver and webserver, then it again works fine.Please give me a solution.
View 1 Replies View RelatedHi,
I have created the below procedure in SQL SERVER 2005.
But when I copy out the same in SQL SERVER 2000. I get an error at the underlined place. It says
Line 32: Incorrect syntax near '('.
ALTER procedure [dbo].[VTELcardvalidation1]
@CardValue1 int,
@CardValue2 int,
@CardValue3 int,@Result nvarchar(50)output
as
begin
declare @CrdPinNo varchar(100)
declare @CrdNo nvarchar(100)declare @count int
declare @inc int
declare @concat nvarchar(200)create table #temptable(crno nvarchar(50),pno nvarchar(50))
--First Card
--Change here
select @count=count(cardno) from vendorcardvalidation where cardvalue=1500 and flag=0if (@count)>@CardValue1
begin
declare cur1 cursor forselect top(@CardValue1) pin,cardno from vendorcardvalidation where cardvalue=1500 and flag=0 order by cardno
open cur1fetch next from cur1 into @CrdPinNo,@CrdNo
while(@@fetch_status=0)
beginupdate vendorcardvalidation set flag=1 where cardno=@CrdNo
insert into #temptable values(1500,@CrdPinNo)fetch next from cur1 into @CrdPinNo,@CrdNo
endclose cur1
deallocate cur1
set @Result='Success'end
else
begin
set @Result='Failure'
end
select * from #temptable
drop table #temptable
end
It seems the the word 'top' will not be supported in sqlserver 2000. What should I do?
Regards
cmrhema
Sir,i am running .net1.1 on my system with sqlserver as my database.I am devaloping an e-trading project in ASP.NET with VB.net.My problem is that,I am not getting the correct syntax to query the database with SELECT(with WHERE clause)in vb.net.Please help me.
View 1 Replies View RelatedHi,
I would like to create groups in SQLServer2000.Do i need to do this by roles or can i create groups for each database.I read some where that there where
no groups for SQLServer7.0. Is this option available for the latest versions.
Any help will be appreciated.
Thanks in Advance.
Ran.
Hai
I wrote a sp in sqlserver2000 and sp consists of 1 input parameter of type datetime and everything is working fine but if i pass the argument of invalid date format it is giving error.Is there any way to handle errors in sps and even if i give invalid format it should not raise errors.Pls reply as early as possible.
Thanks
Aruna
More of a SQL Server problem than a ASP one but hope you can help me :)
Im tryin to do my first data based application using ASP.net and silly me I forgot to add users when I created then database so now Visual Studio can't access it.
Can someone tell me the syntax to add/create a user to MSSQL database so I can then grant them privelidges to the tables.
thanks very much
Tom
hi all,
my problem is failure in the connection to SQLserver2000 remotly( to city a) by enterprise manager or query analyzer via windows authentication ( this error appears "login failed for (domain/user)" ),while no problems happened in the connection when i would to connect to other servers at other locations(to cities b,c) via windows authentication.
note that i can access to (city a)server via sql server authentication , but i want to access to this server(city a) via windows authenication as the other locations because this authentication mode is policy of our system, and note also that persons in city b can access to all servers (city a,c) via windows authenication .
regards,
Hi,
If access database has an extension of .mdb then what is sqlserver2000 file extension?
Hi all,
I created a database maintenance plan with backup + transsactionlog backup+optimizations. The first two jobs work fine but the Optimizations job is failing with error:
sqlmaint.exe failed. SQLSTATE 42000, Error: 22029. The step failed.
User is admin on local box and "sysadmin" in db server role. Any suggestions to resolve this?
Thanks
Vinnie
When I click on Enterprise manager->Database this is the error I am getting:
A runtime error has occurred. Do you wish to debug. Line 306 Error: unspecified error. Yes/No
This is happening on user databases only not the SQL standard dbs; pubs,master,northwind.
How can I fix this?
Thanks for any help.
Vinnie
Wilson writes "Hi, I have Sql Server 2000 on win98, i can't retrieve any data. Instead, it shows an error, says that some files is missing or is not registered.
the mssql was reinstalled and it's goin then same.
what could be the problem? what could be the solution?"
Hi All,
I understand I can use Index tuning Wizard to index a DB. I understand as well I have to feed it with a workload file, which is a collection of queries. I do have a limited number of stored procedure (150-200 in total) being constanlty executed against this DB (around 700MB).
Can I generate a workload file with these storedprocedures optimizing so the DB for their execution?
If yes, how? can someone point out some good tutorial about this?
Any help would be much appreciated,
JI
I created table with "id" field as "uniqueidentifier" (primary key).I connect via ODBC from MS-Acces.-->>> Don't know how to something like "Autonumber" in MS-Access.Let me know If any trigger or something like this is required.Please post some code of trigger if need.Until now I have only developed some native MS-Accessdatabases. I hope there is some solution about "Autonumbering records"in SQLServer.SqlServer 2000, Access Xp.Marek Bąbski
View 2 Replies View RelatedI have 2 questions:
1. How to encrypt data of database in SQL Server 2000 ? Someone can't see true data
if without password or something else.
2. If i have 2 database . All of them have same table, structure, ....How to update or insert or change in the second database when i update or insert or change in the first database automatically ?
Thank you very much.
There is no prompt ' UPGRADE' when I install SqlServer2005
Also check select @@version after installed
Still be 'Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) '
Why does this happened?
OS is Windows2003 Server
Thanks
I am working on Windows mobile platform using C#. I am using Merge Replication to do synchronization between SQL Server2000 and SQL Server 2005 Mobile edition and t is working fine.
The Server Tables are copied in the Client DB. It works fine with one way, i.e., server pushing data to Client Database (in PDA), but when i tried to update from PDA database, server keeps over writting PDA databse.
The requirement is that before adding our PDA database as subscriber,there are some tables with same name and structure as in Server with some records. After that i added it as subscriber and sycnchronized.The tables in the server are going to overwrite the records in PDA. My requirement is to not overrite the records but it should update the existing table.
Is it possible....Can Any one Help meeeeeeeeeeeee plzzzzzzzzzz.
Hi,
Can any1 tell me how to connect to Sqlserver2000 from sqlserver2005 ...I cant see sqlserver2000 instance name when i try to search in database engine
With regards
mahender
hiam working with VS2005(asp,c#),sql server2000.
i uploaded my application to the webserver.when i try to interact with database in my webpages.it is giving error
error:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
actually am using sqlserver2000,but it is giving error regarding 2005.how can i resolve this.
my web.config settings are like this..
<?xml version="1.0"?><!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
WindowsMicrosoft.NetFrameworkv2.xConfig
--><configuration>
<appSettings>
<add key="cn" value="User ID=redot;Password=redot;Data Source=216.185.43.148:8077;Initial Catalog=redot" />
<!--<add name="redotConnectionString" connectionString="Data Source=REDOT;Initial Catalog=redot;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>-->
<!--<add key="smtpServer" value="smtp.mydomain.com" />-->
</appSettings><connectionStrings>
<!--<remove name="LocalSqlServer"/>--><!--<add name="ConnectionString" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot; Password=redot"providerName="System.Data.SqlClient" />-->
<add name="redotConnectionString" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString1" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString2" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString3" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString4" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString5" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString6" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString7" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString8" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString9" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
<add name="redotConnectionString10" connectionString="Data Source=216.185.43.148:8077;Initial Catalog=redot;User ID=redot;Password=redot"providerName="System.Data.SqlClient" />
</connectionStrings><system.web>
<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=216.185.43.148:8077;User ID=redot;Password=redot;Trusted_Connection=True"cookieless="false" timeout="60"
/>
<compilation debug="true" />
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user. -->
<!--<customErrors mode="Off"></customErrors>-->
<!--<customErrors mode="On" defaultRedirect="error.aspx"/>--><!--<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />-->
<customErrors defaultRedirect="http://seafarersjobs.com/errorStatus.htm" mode="On">
<error statusCode="404" redirect="filenotfound.htm" />
</customErrors></system.web>
<system.net><mailSettings>
<smtp><network host="216.185.54.55" port="25" />
<!--password="123456" userName="redot"--></smtp>
</mailSettings></system.net>
</configuration>
can anyone help me ASAP ..pls
Thanks
Shobha
I only can install client-side of SQLServer2000 on Win2kProfestional
But i need to set up server-side, so can i?
In our project we r having a task such that to convert the excel data to sqlserver2000 . what is the procedure ? (Bulk amount of data )
View 2 Replies View RelatedHi,I am unable to load data in dataset via sqlconncetion object. Always i get error at ds.fill.Thanks in advance. PLS Help.Sudipta Datta www.geocities.com/dattasudipta
View 1 Replies View RelatedHi, i had installed on a lan, sql server 2000 (administrative and client tools) on workstations with windows nt4 ws.
The problem is that i shouldnīt give users permissions of "local administrator".
If I give them permissions of only "local users" they canīt start sql services, but they can start the enterprise manager.
If I give them permissions of "advanced users" they can start sql services, but they canīt start the enterprise manager.
What can i do for this to work well, without give them manager rights?
Thank you.
Hi,
I want to setup disaster recovery site for small databases from disffrent data centre.Which method would be good and from where I will get some good stuffs to read except online documents?
Hi,
I have SQLServer20000 Enterprise Manager-Version 8.00 and Microsoft Enterprise Manager - V 2.0 Version 5.1 Service Pack 1 and SQL 8.00.760. A "user" owns the database and when I have the user logged to SQL Query Analyzer ( with user and pwd)
When enable Fixed server role as system administrator for that user (owns db)
select * from table1 says that the table does not exist
select * from "owner".table1 gives the records.
When enable fixed server role as security administrator for that user ( owns db)
select * from table1 outputs records
select * from owner.table1 outputs records.
If I have both system administrator and security administrator checked for the user the scenario is like "system administrator" where select statement outputs records only if owner is included in the statement.
When system administrator is the highest role why does it behave this way?
Any help is appreciated.
Thanks
Vinnie
The SqlServer2000 error logs go to Program FilesMicrosoft SQL ServerMssqlLog directory by default.
How can I change their location. I could change SqlServerAgent logs but did not find any help or way to change the location of these. Would anyone please help?
Thanks
Vinnie
I want to be able to see the last login for every user, even if it was
before today in any user database combinedly listing all. Tried to query master..sysprocesses but the last_login or last_batch shows just for today. Can someone help with code or table query how to get this information. Auditors want to see when any user has last logged into any database. Any help is appreciated