Is there a way in SQL 7 ( NT ), one can allocate how much CPU time to be
used for a big query or a job, so others can work and not feeling much of
performance hit ? Looks to me when a query is submitted, server used all of
available resources and slow down other user requests.
Thanks for help.
hi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed
I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.
I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.
My next question, How to configure MAPI in Sql server if what I did was wrong.
Hi, I have 2 windows 2000 server in cluster with sql server 2000 enterprise edition installed.
I have activated the Server-Requested Encryption by using the sql server network utility (Force Protocol Encryption). After this, I have stoped sql server service. But I can't start it at this moment.
The error is:
19015: The encrypton is required but no available certificat has been found.
Please help me to start sql server.
Thanks.
Michel
This morning I can not connect to our SQL Server 7.0 whatever from client or server. The error message which I list below:
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
A connection could not be estabished to server--Timeout expired
Please verfy SQL Server is running and check your SQL Server registration properties and try again.
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
We use windows NT authentication. We did not do any change on NT. The SQL Server daily schedule job usally stoped at 10:00AM, but today from the Window NT Task Manager, we can see that the SQL Server is still running untill now.
Please help!!!
Hello,
I am facing a huge problem in my sql server database using access as a front end.The main problem is trying to execute queries "views" ,since they reside on sql server now,and using variables or parameters in reports and forms to filter on this query.
Ex.
how can the following be implemented using the same query but in sql server?
Access
------
SELECT MAT_Charts.YYYYMM
FROM MAT_Charts
WHERE ((([Area_Code] & "-" & [GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
GROUP BY MAT_Charts.YYYYMM;
It is specifically this statement in which I am interested:
[GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
Thank you very much for your concern.
Hello,
USE master
GO
SELECT a.*
FROM OPENROWSET('SQLOLEDB','Server1';'sa';'password',
'SELECT * FROM master.dbo.sysdatabases ') AS a
if @@rowcount <> 0
print' failure'
If @@error <> 0
print 'failure'
The server is down and I want it to print failure
but it don't goes to if statement but gives
Server: Msg 11, Level 16, State 1, Line 2
General network error. Check your network documentation.
Is there a way I could let it go to if statement, Or anyother way
to check that the server is down
Thanks
Rea
i want to create fulltext search for that i have started Microsoft Search component but when i am tring to open SQL server Enterprise manager, i am getting sql server group but it showing "no items" not any database or any other data. what to do.
please help me out.
hi all i try all date convertion function that u imagen in my asp.net project to insert a date to sqlserver datetime field but always sql server get the data as "1/1/1900 00:00:00"
how can i fix that from sql server
plz
Hello,
There is Production server with different Unicode Id and its standard edition, I need to build the server with same configuration of production server, Can anyone help me as to how to get all the info of the server
Thanks
Ekta
I'm running 7.0 sp2,windows 2000, 1gig of ram, and a 933mhz cpu. Server has been very stable with no problems until I moved a 2gig table into the database. Query performance is excellent even table scans take less than 2 minutes. The problem is that once a table scan is performed on the table (I can't index for every possible query) the query finishes but the enterprise manager freezes on the server and users can no longer connect. I've set SQL server to have only 650 MB of ram and the rest is free, problem also existed when the memory was controlled entirely by SQL server.
My cache Hit Ratio was 97% and Cache flushes 0.0 (unfortunately these can't be checked when the problem exist because the box is frozen). I may have a concurrency issue but I'm not sure how to be positive. I don't want to just throw memory at the problem because I'm not sure the problem will be fixed.
Thanks for any help, Dave
I have a Sql Server cluster set up in an active/active configuration. It is running NT4.0 SP6 and SQL Server 7.0. The problem is that node 2 has failed over to node 1 and whatever I try, I cannot get node 2 to failback. I think I have tried just about everything. Any SQL Cluster gurus out there ? Any help would be very much appreciated. Thanks in Advance
View 2 Replies View RelatedI cannot connect to SQL Server 7.0 in EM or Query Anlayser, but I can in ISQL(dos), using either sa account or trusted connection.
Error message in QA is just
ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC SQL Server Driver]Timeout Expired
Does anybody have any ideas ?
thanks
Hi Everyone,
I'm having a problem with linking two different servers..basically what i need is to run a stored procedure from server b where the tables are present in server A i tried out this on test using sp_addlinkedserver it worked fine but when i'm trying to use the same process real time its giving me this error message. server A is Baan and Server b is Baan-test.
[OLE/DB provider returned message: Client unable to establish connection]
[DBNMPNTW]ConnectionOpen (CreateFile()).
what i did is use this procedure link the server and run the command from the destination server.I thought the login has a problem so made sure that the login for sa and pwd are same at both ends.
Or could anyone guide me through an alternative approach which can be imlemented.
In advance Thanks for your Help.
Hari
Hi ,
I am an Informix user who has shifted to SQL Server,,,,I just wanted to know the equivalent of 'ISOLATION TO DIRTY READ' as in Informix in SQL SERVER....
Thanks,
Visitor
Can I backup a db which is on server1 by sitting at server2 by way of running a script on server2.
Thanks.
Hello,
My Production server has Windows NT and Sql server 7.0 installed, there are 3 drives my data lies on physial E: which is 8.46 GB and 1.91 GB is used it is mirrored. I need to create a Database with two tables with varchar, datetime and numeric columns. the data would be 30 millions. everynite 10 millions data would be deleted and then same amount would be inserted. During day time it would be only selects on that database.
My main corncern is can SQL Server handles this big db and does inserts and deletes be completed in 7 hrs during nite?
Pls guide me
Qinglee
I have a very urgent situation and to do with SQL Server 6.5, cannot start and the error message I got was: Initdata: Suballocation for buffer pages failed (838860 Bytes requested. Can anyone help me urgent matter.
Regards,
Hi,
I am installing the SQL server 7.0 as a production server and as soon as the server is started, within a week the date will be around 10 millinon rows, so I want to know how much space should I allocate for the tempdb and what should be the incremental percentage of the the tempdb(New server).
thanks in advance,
Madhu.
Hello,
We stopped one of our SQL Servers from the SQL Enterprise Manger earlier. For some reason it doesn't want to start back up. I deleted the SQL Server registration for that box in my SQL Enterprise Manager. Tried to register it again and got the error message: "General network error. Check you network documentation.|ConnectionOpen(connect().
I restarted the box. The SQLServerAgent services were configured to start automatically, but they don't start the server. I tried to do it manually, didn't help.
Is there any way to start the server from the DOS command line, or some other way?
Thank you very much.
I am unable to connect to the SQL Server if i am not logged on to the NT domain.
Is there any way i can connect to the SQL Server even if i am logged on to only my workstation.
I get an error :
Unable to connect to server.
ConnectionOpen ( Createfile() )
Thanks in advance,
Deepak.
I upgraded a sql server 6.5 database to sql server 7.0,
When I go into Enterprise manager and click on any of the system tables
and say 'Design Table',I get the following message
"column type in sysobjects is a computed column,it will be converted
into a non computed column if any table is recreated."
This error i get it for all columns and for all system tables.
Please Help I need a reply urgently.
Megha
Can anyone guide me how I can insert the rows in table from the table which is located on another server
insert into table1
select * from serverB.database1.dbo.table1
Is it possible?
Hi
i cant start the server.....,its giving following error in
nt event viewer,any help please
we are running on sqlserver 6.5
Error : 1105, Severity: 17, State: 2
Can't allocate space for object 'Syslogs' in database 'master' because the 'logsegment' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
thanks in advance
bye
ram
Got a 5.5GB database created on a Windows 2000 server with latest service packs.
Running under Exchange 6 (2000) with service packs.
Server went down and the client had no backup. This, despite having a similar (yet smaller) problem back in April this year.
I've run all sorts of utilities on the database file; third party, stuff from OnTrack, etc - nothing works.
Best result I've had has been 1.7GB of data - but a heck of a lot was missing.
I've tried running eseutil in all its guises - but still, using an edb viewer, plenty of corruption is reported and about 10% of the data comes out in the wash.
I think I have a problem in that I don't have Server 2000 or Exchange 2000 to test it with - but I doubt it is even possibly to test it.
That's the long and short of it.
To make matters worse, all the client did was copy the database folder to a dual-layer DVD and reformat the hard drive for use in another system - so I can't even examine it forensically to get a clue why it failed.
Any help?
I have a windows-based application that I use to manage fitness events (road races, mountain bike races, etc.). I have the application set up on multiple computers for three reasons:
1) We often manage multiple events on the same day, and
2) I back-up race data during the event in case of catastrophic data loss/hard drive crash/etc.
3) I am trying to set up the possibility of letting race participants sit down and enter their registration data on a laptop to save our staff (generally me) from having to enter several hundred ourselves on the morning of the event.
That is the scenario. Here is the problem: the entire system works very well on our domain/network but when I take the system to a remote site and set up a work-group it is not reliable in the sense that it sometimes works but other times times out.
For instance, lets say a participant sits down at computer 1 and enters their data. The data is sent to sql server on computer 2 via a vb6 windows application. And a registration form is printed out on a computer connected to computer 2 and shared amongst all of the workgroup computers. In some cases it works but generally speaking it times out. Often times if I set the workgroup up at my location it will work but not at a remote location. Several of the computers have wireless capability which I use at home but not at the race site. I connect to the workgroup via cat 5, etc...
The thing that frustrates me is that it works at home but not on the road. Are there any sql server gurus that can point me in the right direction? I REALLY need to get this resolved.
Thanks in advance~
How can i solve this problem ???
Error: QueryEngine encountered error: Call SQLExecDirect got SQL_ERROR
[37000:1101: on HSTMT] [Microsoft][ODBC SQL Server Driver][SQL Server]Could
not allocate new page for database 'TEMPDB'. There are no more pages
available in filegroup DEFAULT. Space can be created by dropping objects,
adding additional files, or allowing file growth.
Error in Process method of Component: QueryEngineServer, Project 11, Job
14797, Error Code= -2147212544.
I already saw the growth and it is correct, i have already set it to 96%.
I have disk space.
How can i solve this problem
Thanks.
Hi All,Our SQL Server just crashed with the following messages:The Scheduler 5 appears to be hung. SPID 85, ECID 0, UMS Context 0x06C22478.Error: 17883, Severity: 1, State: 0We are running SP3 on cluster on a SAN.Any ideas?ThanksMichael
View 1 Replies View Related
Hi All,
Iam Using sql server report ..how to declare"Report document" class in windows application ..
its any syntax is their..I mentioned below.for example crystal report "Report document" class..
that same class how to declare in sql server report "Report document" in windows application
Syntax:
------------
ReportDocument rpt1 = new ReportDocument();
When I am giving http://localhost/ReportServer/ in internet explorer the following error is coming please help us. We already installed the report server
Server Error in '/ReportServer' Application.
The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFramework64v2.0.50727Temporary ASP.NET Files'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFramework64v2.0.50727Temporary ASP.NET Files'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[HttpException (0x80004005): The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFramework64v2.0.50727Temporary ASP.NET Files'.]
System.Web.HttpRuntime.SetUpCodegenDirectory(CompilationSection compilationSection) +1036
System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +409
[HttpException (0x80004005): The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFramework64v2.0.50727Temporary ASP.NET Files'.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +709
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +317
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +595
Hi All,
I have to set Amount field properties to "Currency"
i got the answer like this:
$123
$234324.498
$-34343.55
$-33.00
how to change negative sign like this.., any properties is there
-$34343.55
-$33.00
I have downloaded the sql server 2005 express edition from the MSDN...but i cant figure out how to create the database there....no database engine is shown where I can proceed.Only Configuration tool is shown...how do i go about it...pls tell me asap.thanks
View 4 Replies View RelatedHi,
I created sql server Main & sub reports ...But i didnt get supreport in window application
Its Shows only Main report.
The Error Shown: Could Not Be Shown Subreport
How to call subreport in windows application...any coding is their.. its working backend (Main & Subreport reports)but its not working windows application. its shows only main report . I Mentioned my coding part below:
public partial class Form1 : Form
{
private string str = @"Uid=sa;pwd=systems;Data Source=Spring;Initial Catalog=VPMS";
private SqlConnection con;
private DataSet ds = new DataSet();
private SqlDataAdapter da;
private DataTable orderDetailsData = null;
private DataTable LoadOrdersData()
{
this.con = new SqlConnection(this.str);
this.ds = new DataSet();
this.da = new SqlDataAdapter("exec STP_RP_AR_ENCOUNTER", this.con);
this.da.Fill(ds, "OrderData");
return ds.Tables[0];
}
private DataTable LoadOrderDetailsData()
{
this.con = new SqlConnection(this.str);
this.ds = new DataSet();
this.da = new SqlDataAdapter("select * from VW_RP_SHR_Superbill where 1=1", this.con);
this.da.Fill(ds, "OrderDetailsData");
return ds.Tables[0];
}
private void SubreportProcessingEventHandler(Object sender, SubreportProcessingEventArgs e)
{
if (orderDetailsData == null)
orderDetailsData = LoadOrderDetailsData();
e.DataSources.Add(new ReportDataSource("Ds1", orderDetailsData));
}
public Form1()
{
try
{
this.Text = "Report Control Demo";
this.ClientSize = new System.Drawing.Size(700, 600);
ReportViewer reportViewer = new ReportViewer();
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.LocalReport.ReportPath = "RP_SHR_SuperBillPrint.rdl";
reportViewer.LocalReport.SubreportProcessing +=
new SubreportProcessingEventHandler(SubreportProcessingEventHandler);
reportViewer.LocalReport.DataSources.Add(
new ReportDataSource("Ds1", LoadOrdersData()));
reportViewer.Dock = DockStyle.Fill;
this.Controls.Add(reportViewer);
reportViewer.RefreshReport();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.reportViewer1.RefreshReport();
this.con = new SqlConnection(this.str);
this.ds = new DataSet();
}
}
}
Please Help me Very Urgent:
Does anyone have any suggestions? Thanks.