Stop running sql server at start up


I'm attempting to fine tune my laptop to make it run quicker.
It's running very slow at the moment. So many processes running using svchost.exe
I'm using windows xp

I have noticed sql server always running and I would assume this would consume a lot of cpu.
I dont need this to run, or do I
It automatically starts at start up.
How do I stop this please assuming I dont need sql server running
Posted On: Tuesday 20th of November 2012 02:35:58 AM Total Views:  510
View Complete with Replies

RELATED TOPICS OF Microsoft SQL Server PROGRAMMING LANGUAGE




Sqlserver2000

hi what are advanced features in sqlserver2000 which are not in sqlserver7. i mean to say what differences they have thanx
VIEWS ON THIS POST

174

Posted on:

Tuesday 20th November 2012
View Replies!

Urgent!! - copy column data to remote server

hi, really need some help with this I asked my webhost to drop a full-text index on a column so I could make a change to the column size, but they dropped the column!!! So now I've lost the data on that server. Luckily, I got them to give me a backup so I could make sure I didn't lose the data when I dropped/recreated the column. What I don't know is - how do I run an update statement across 2 servers I've never done this before. The database names are the same on my local and the remote. The remote machine doesn't have a name, just an IP address. I've been trying select statements across the 2 but I can't get it to work.
VIEWS ON THIS POST

253

Posted on:

Tuesday 20th November 2012
View Replies!

sql server datetime comparison

Hi all, I wanted to construct my sql query such that it returns rows that were added only between or during a particular year. There is a 'DATETIME' field in the rows and for e.g I want to say something like ... select * from table where (year in datetime_field) > 2000 or select * from table where (year in datetime_field) = 2004. Any ideas
VIEWS ON THIS POST

168

Posted on:

Tuesday 20th November 2012
View Replies!

Copy SQL from server to local?

OK, I'm very new to SQL but I need to obtain a copy of the live database so I can setup a local test site. I don't intend to modify the SQL database AT ALL. I can see the database via Enterprise Manager but I'm not game to try anything in case I stuff up the live website - I would lose my job! Can someone tell me the best method of copying the database from the live server to my local machine and how to setup so I can run a local website connected to the test SQL database. I gather I must have appropriate server permissions to backup/copy Please help!
VIEWS ON THIS POST

258

Posted on:

Tuesday 20th November 2012
View Replies!

.EXE don't work on the server

I'm moving to a new server, and it seems that executable files don't work. Even though the path is correct, the message error is: "The page cannot be found". Why it doesn't recognize this extension Is there something to do with IIS Thank you
VIEWS ON THIS POST

228

Posted on:

Tuesday 20th November 2012
View Replies!

how to transfer a database from one server to another

Im sure this is somethign obvious im missing i have a database running on my local server and i want to transfer its contents and structure to a remote one on the internet. ive used the DTS wizard and selected my local dbase as the source and the server on the internet as the destination. Ive then selected all the tables and data to transfer. problem is i get lots of errors "violation of PRIMARY KEY constraint 'PK_tablename'. Cannot insert duplicate key in object 'tablename' I presume this is because within the remote database some old records remain and when copying from my database its adding these records as well as the new ones but cause the old ones are already there it causes the problem any way around this help appreciated
VIEWS ON THIS POST

244

Posted on:

Tuesday 20th November 2012
View Replies!

Restoring full-database on server

. Im stuck on something very essential. How do I transfer my entire SQL Database with tables,procedures and users from my personal workstation to another server I used the Backup function to save a backup as a file. Restoring the file on the server returned only my stored procedures, without the tables.
VIEWS ON THIS POST

263

Posted on:

Tuesday 20th November 2012
View Replies!

Hosting SQL 7 databse on SQL 2000 server

I had a working sql 7database, which I eventually hosted on a sql 2000 server. I now find that some of my tables have gone missing. Please let me know if I have to do anything specific to my sql 7 database before hosting on the sql 2000 server
VIEWS ON THIS POST

187

Posted on:

Tuesday 20th November 2012
View Replies!

Cannot Connect to Analysis server

Server instalation: MSFT Sql Server 2K (SP3) Analysis Server (SP1) Client instalation: Analysis Manager (MDAC 8.0) Client user is a member of group OLAP Administrator When i try to connect from client (Analysis Manager) to Analysis Server over LAN i get this message: Cannot connect to Analysis Server Network error. Can anyone help me
VIEWS ON THIS POST

170

Posted on:

Tuesday 20th November 2012
View Replies!

probelm with asp and sql 2000 server

hi, help needed!!!! i want to connect SQL with ASP using connection string .how to install sql 2000 server on windows xp professional edition .
VIEWS ON THIS POST

175

Posted on:

Tuesday 20th November 2012
View Replies!

sql server 2000 on win2k VS 2k3 problem

Hi all, I'm running into a problem that has me absolutely stumped. In my environment, we have 3 locations, and thus 3 file servers and 3 sql servers. 2 of these locations are on 2k advanced, and the third is on 2003 server. The problem i'm having is involving an ASP script. To make a lot of code short, -asp page passes in vars to a store procedure -stored procedure populates a temp table and uses a sysobjects temp table as well -temp table is then joined to a View In the view lies the problem. in alter mode, it looks like this: Code: ALTER view dbo.vw_DSHistory_1 as select top 100 percent datepart(hour,calltime) as HourOfCall, cast(left(callTime,11) as datetime) as DayOfCall, agent, reason, finishcode, resultcode, status, c.job_name from SJ4005_CallHistory as h join SJ4005 as c on h.i3_rowID = c.i3_rowID where calltime between '08/03/2004 8:00:00' and '08/03/2004 23:59:59' order by cast(left(callTime,11) as datetime), datepart(hour,calltime) The dates and 'SJ4005' is a dynmaically written view passed in vars to the store procedure. Code: insert into @tempResults (fields) --values in a select: select . . . . from vw_DSHistory_1 h group by h.Job_Name, h.DayOfCall, h.HourOfCall order by h.DayOfCall, h.HourOfCall, h.Job_Name This all works 100% on two of our servers. word for word copy paste onto our 3rd, on 2k3, and the view is not updating the variable fields. Is there a setting im missing does 2k3 have some kind of permission issue with passing a var from more than one thing (asp -> sp -> vw)
VIEWS ON THIS POST

281

Posted on:

Tuesday 20th November 2012
View Replies!

Differenec between access & sql server

I know and have worked with MS Access for over 3 years now. Just would like to know if there is very much difference between MS Access and SQL Server. Are they similiar or are they completely different. In terms of designing forms, reports, sql. Appreciate some feed back and also where I could view or look at sql server.
VIEWS ON THIS POST

194

Posted on:

Tuesday 20th November 2012
View Replies!

two servers 1 being remote

There is a remote server being set up that is a database (sql2K) This server will store paths to its folders containing scanned images (images around 250k each) I have a website that has a calendar of events, the user of the calendar can have the ability to select supporting documents for the event they create on the calendar (so the calendar event needs a link to the documents on the other server. The website is fully under a ssl key and the remote db server is not. I don't was to inconvience users / give up security by having them click a link to load files from an unsecure location. How would it be best to keep the security of the ssl and create a link from the secure web calendar of events to unsecure supporting documents on another server. When the user uses the calendar of events, since it is dynamic, the users login information is passed along so the user views their information. This is what i was thinking, would it be possible to pass the users Login information to a store procedure in remote server (which would only be listening for the web servers ip address) THis procedure would then pass back to the website (at a different ip) the urls to the images. My main issue is avoiding the security prompts created from importing unsecure info and clicking a link to unsecure info FROM a secured. Any suggestions on how i can do this
VIEWS ON THIS POST

250

Posted on:

Tuesday 20th November 2012
View Replies!

Text data type in sql server

hi , can any one tell me how "text" data type is used in sql server especially in writing stored procedures.
VIEWS ON THIS POST

195

Posted on:

Tuesday 20th November 2012
View Replies!

MS sql server to MS access

my web system ( asp code ) is build in sql server database. After i change or convert to access database. my web system got an error ( Microsoft JET Database Engine (0x80040E07) Data type mismatch in criteria expression. ) pls help me and tell me why this happen and how to solve it.
VIEWS ON THIS POST

171

Posted on:

Tuesday 20th November 2012
View Replies!

Creating Table With Programming in server

hi I restored my database in my server but as I heard I should create My tables with programming and put them in db folder to make them known for server But I dont know how to do that Becouse in my own PC with IIS I just create them in SQLSERVER and there was no problem please help and guide me tanx
VIEWS ON THIS POST

163

Posted on:

Tuesday 20th November 2012
View Replies!

create running counter for SQL data (select)

for eg i got previous data such as customer name --------- jim kim roy how do i create counter in the select statement, so that the result appears as no customer name --------------- 1 jim 2 kim 3 roy
VIEWS ON THIS POST

258

Posted on:

Tuesday 20th November 2012
View Replies!

help....can't even install SQL server in XP!

Hi all, i need help for the installation.. SQL server 2000 gave me the error "The logon account cannot be validated for the SQL service . Verify that the user name and password entered are correct. The logon attempt failed." I used my windows XP administrator account username and password .. why it won't allowed me to install using a Domain user account instead of the local system account\t The funny thing is that i did installed SQL server before but the SQL server service cannot be logon when i tried to use it..so i reformatted my HD. Please help.....i do not wish to reformat my HD again or use the local system account during the installation. Local System account vs Domain User account.. which is better\t
VIEWS ON THIS POST

248

Posted on:

Tuesday 20th November 2012
View Replies!

SQL server Reporting services

I have generated reports using SQL server reporting services 2000. I need to put a print button in the report tool bar which will prints the content displayed in the report(only the report content). Can any body tell me how to enable the print option in the tool bar.
VIEWS ON THIS POST

290

Posted on:

Tuesday 20th November 2012
View Replies!

Which mode SQL Server is running???

Hi Everyone, After connecting to the instance, as a user/ developer can i know in which mode my SQL Server is running (i.e MULTI_USER mode or Single user mode). Is there any query to get this information.
VIEWS ON THIS POST

268

Posted on:

Monday 26th November 2012
View Replies!