Server ( Urgent )

Feb 22, 2001

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.

View 1 Replies


ADVERTISEMENT

URGENT.Sql Server Does Not Recognise MAPI , Or Profile Name URGENT

Oct 26, 2000

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.

View 1 Replies View Related

Urgent, Urgent !! My Sql Server Refused To Start Due To Encrypton

Mar 23, 2001

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

View 4 Replies View Related

Timeout Expired -- URGENT, URGENT, URGENT!!!

Sep 27, 2000

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

View 3 Replies View Related

Urgent Urgent Please.(Access SQL Pass Through Queries)

Jul 6, 2000

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.

View 2 Replies View Related

Server Up (Urgent)

Dec 4, 2001

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

View 1 Replies View Related

Sql Server 2000--urgent

Jun 16, 2007

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.

View 1 Replies View Related

Urgent Configuring Sql Server

May 29, 2008

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

View 8 Replies View Related

Server Info(Very Urgent)

Apr 17, 2002

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

View 1 Replies View Related

Urgent: Server Keeps Hanging

Apr 4, 2001

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

View 2 Replies View Related

Urgent !!! - SQL Server Cluster

May 1, 2001

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 Related

Urgent -- Cannot Connect To SQL Server

Jun 27, 2001

I 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

View 2 Replies View Related

Linked Server (Urgent)

Feb 16, 2001

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

View 3 Replies View Related

Informix------SQL Server.....URGENT

Feb 21, 2000

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

View 1 Replies View Related

Backup From A Different Server. URGENT!!!

Jan 22, 2001

Can I backup a db which is on server1 by sitting at server2 by way of running a script on server2.
Thanks.

View 2 Replies View Related

Can SQL Server Handle?(Urgent)

Jan 23, 2001

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

View 1 Replies View Related

Very Urgent Situation (SQL Server 6.5)

Apr 3, 2002

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,

View 1 Replies View Related

Urgent, How Much The TempDB Should Be In The New Server

Dec 28, 1999

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.

View 2 Replies View Related

Start SQL Server - Urgent

Aug 22, 2000

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.

View 5 Replies View Related

Connecting To Server - Very Urgent

Mar 9, 2000

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.

View 5 Replies View Related

Sql Server 7.0 Upgrade_Please Help Urgent

Jun 8, 2000

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

View 2 Replies View Related

Inserting In Different Server(Urgent)

Nov 7, 2001

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?

View 2 Replies View Related

I Cant Start My Server (urgent Please)

Aug 22, 2000

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

View 1 Replies View Related

Urgent MS SQL Server Recovery

Oct 19, 2005

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?

View 1 Replies View Related

SQl Server App On Multiple PCs-URGENT

Jul 1, 2006

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~

View 1 Replies View Related

Sql Server Error (urgent)

Jan 8, 2004

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.

View 14 Replies View Related

URGENT - SERVER CRASH

Jul 23, 2005

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

Sql Server Report ---Urgent

Dec 20, 2007


View 6 Replies View Related

Urgent SQL SERVER REPORT

Aug 14, 2007

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();

View 1 Replies View Related

Please Help Me Very Urgent - Report Server

May 8, 2007

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

View 9 Replies View Related

Sql Server Report -Urgent

Nov 1, 2007



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



View 5 Replies View Related

CAN ANYONE PLS HELP ME ON THIS--REGARDING SQL SERVER Installation....VERY URGENT

Sep 12, 2007

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 Related

Urgent Help Me:(SQL SERVER REPORT)

Jul 21, 2007

Hi,



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.


View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved