Hi all
im new to SQL 2005 and im regularily works with sql 2000 and queryanalyzer as the tool for running .sql scripts..
in sql 2000 after connceting once to the server i always open .sql files from a folder and running them one by one...
in sql 2005 after openning each file i have to conncet again to the server.. is it a property or by design???
tks in advance..
Or
Hi, I am running SQL Server 2005 x64 DE on Vista x64. I installed MS VS 2005 Pro. Edition. During the setup of VS, I did a custom install, un-checking the SQL Express addition box. After installation, I received errors that indicated the SQL Express did not install. Even though I do not have SQL Express installed on my machine, MS Update says that I need SQL Express SP2. My SQL DE is up to date with SP2 and MS Update indicates as "optional" that I need SQL SP2.
Is SQL Express a necessity for VS Pro? If not, why is MS Update indicating that I need SQL Express SP2? In addition, why is MS Update telling me I need SQL SP2 when it is already installed?
Note: I installed SQL SP2 manually, not through MS Update. This makes me believe that MS Update is not detecting it.
Thanks in advance to anyone who can help,
Abel
I'm having some problems debugging SQL Server stored procedures on a SQL Server 2005 server. I have installed Visual Studio 2005 on a workstation running Windows XP, now I'm trying to debug a ASP.Net web application that has some code that executes the stored procedures on a Windows 2003 Server running SQL Server 2005.
I opened VS2005 ... created a connection to the SQL Server 2005 instance ... open the Stored procedure ... right click the stored procedure name and selected Step into Stored Procedure and the following message is displayed:
Unable to start T-SQL debugging.Could not attach to SQL Server process on 'ServerName'.
Any ideas.
Thanks,
Hi, I need to write a script to run an automation in MS SQL 2005. It will run every 10 hours. What the script will do is just import a .cvs file into a database table. Can someone let me know how can I acheive this? Thanks in advanced.
View 2 Replies View RelatedHi, I am migrating my client's site from SQL 2k to 2005. The site was built on .NET 1.1
In order to run SQL 2005, do we need to upgrade to .NET 2.0 in order to run the site?
If we do need to upgrade to .net 2.0, is there any way to get around the problem and run it on .NET 1.1. This is because we have a lot of 3rd party componenet which only support .NET 1.1
Thanks in advance.
Paul
Hello
We have a problem with MS SQL 2005 Standard on a Windows 2003 x64 Box.
Server MS 2003 Server x64 R2
Quad Core 2.13GHz
Memory: 12 GB
MS Sql 2005 Standard, Sp2
The Sql process uses only 80MB of RAM (from 8 GB) so this machine is very slow. We set the min and max Memory in SQL without success. SQL ist very slow. Has anyone here some hint's to solve this problem? Thank'.
rainbow1
Hi,
I've installed sql2005 on a windows 200 server. now the requirement is to install sql2000 also on the same server.
Would like to know if any have experienced and type of problem on having both sql on same server. and if there is any impact on installing sql2000 after sql2005.
thanks in advanced
Hi all,
I am having a problem ,SQL server is running very slow.This is happening some days only.For example my stored procedure ususally runs less than 2 minutes, some days will take 13minutes.I dont understand the problem.All the stored procedure having the same problem.Sorry, I am not a DBA,basically a devloper.Daily morning we are taking the DB backup and indexes already applied.DB size 10461.06 MB,RAM 4GB,CPU usage is less than 50%,This is a Cinema Database,so lot of users are accessing at same time(Web,IVR,cinema ticket counters etc).We are using SQL reports.Because of the stored procedure running slow,can not view the reports.pls advice..
please help me..If you need some more information please ask ..
Thanks in advance.
I have a hosted solution where the web host provider tells me I'm running on a 2005 platform, but when I check the DB options, it shows compatibility level 80. The provider tells me I'm not losing any performance by running in the lower compatibility mode. Is this truly the case? What else am I losing out on in terms of features or capabilities?
View 11 Replies View RelatedWhile executing DTS packages in SQL 2005 64-bit Enterprise Edition (we
haven't moved to SSIS yet), I am seeing the following message in the log
files, even though the DTS package runs successfully and does what it is
supposed to do:
GetRegValue(): Unable to RegQueryValueEx() The operation completed
successfully.
From the expression itself, it looks like something to do with registry.
But, nowhere in the DTS package I am reading or querying the registry, so I
am not sure why the DTS package is trying to access registry.
Executing the same DTS package in SQL 2000 does not have this problem.
Can somebody please help..?? I've had one instance when this DTS package ran
successfully but did not transfer the data, it basically ran without doing
anything. I am thinking this message in the log file might be related to this
behiviour. Did anybody else come across this issue..?? Is there a solution to
it..?? Can somebody please help...??
Thanks..
I have seen information on the web about running two versions of SQL at the same time on the same server but was wondering any tricks of the trade regarding it. The main recommendation that I have seen is to have SQL 2000 SP4 running first as the default instance (which is my current situation on a development server) and then install SQL 2005 as a named instance on it. Should the SQL 2005 installation place its files in a dedicated directory (ie, C:SQL2005) as opposed to the default directory that the installation would normally write to, thus not overwriting any SQL 2000 system files? Any other recommendations?
View 1 Replies View Relatedhi friends,
i created the one package for import the data from excel to server 2005
in intellegence services i add the package after deploy
if we run the package (by giving the connection working fine)
BUT I WANT TO RUN THE PACKAGE BY DAILY AUTOMATICALLY(just like a scheduler)
is it possible if possible please give me the coding for auto run a packages
regards
koti
I'm facing several problems that I tryied to short out by msdn but could not get solution
I'm using visual studio .NET 2005 Beta(WHIDBEY),and
problem: sql server2005 Express edition is not running on My stand alone machine(AMD Athlon Xp 2000+,512 MB DDR Ram,CPU Clock speed 1.67 GHz)
Whenever I try to connect to SqlExpress using the server explorer in the VisualStudio.NET 2005 using follwing option in connection properties Dialog Box :
1.server name: the name of my computer(I'm using the Default Instance of SQLEXPRESS 2005) 2.Enter Information to log on to the server:usewindowsNt Integrated Security3.when I go to select the inuilt data base like masters it gives following Error message:-
"Shared memory provider:Specifed Module could not be Found"
Does anyone know whether or not both versions can be installed on the same machine?
View 1 Replies View RelatedI go to the server configuration, cause I want to create a database, once there, I don't see any services running.
I really don't think this is normal.
Have I done something wrong while setup ?
Thanks for your help.
Dave
Hi guys
We are in the processes of finalising or server architecture for our production environment and the proposal that has been put forward is to run the database within SQL Server 2005 which is running in a virtual machine. It is thought (by some) that this provides a very high degree of redundancy as it will use ESX server and will have multiple servers in the farm that it can move to in the event of a server crash (which i admit makes a degree of sense).
I however am worried about performance. I release as soon as you go to virtual you loose some raw power because the box is busy running the virtual but more from the point of view that if we make cretin hardware resources available to the virtual would the server run the same as if it was running on a physical machine of the same specifications. For example, if 4gb ram and x amount of clock cycles where dedicated to the virtual would it preform the same as running it on a physical box 4gb ram and x amount of clock cycles. If the answer is no, any supporting documentation that anyone knows of would be greatly appreciated.
As a side note if it makes any difference the database data files and transaction logs are being sorted in an external SAN and not within the virtual image itself.
Thanks
Anthony
Hi,
I have three systems that running different version of SQL sever..
1. my notebook - SQL Server Express 2005
2. my WS - SQL Server 2005 Standard
3. my server - SQL Server 2000
I installed SSEUtil to all of them and only the notebook works..
I read the Read me but it doesn't help me resolve my problem so I hope someone from this forum can help me out..
The problem:
Running sseutil on system 2. and 3. get this error, but not on 1.
SSEUtil
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: 26 - Error Locating Server/Instance Specified)
Additional information:
The service 'MSSQL$SQLEXPRESS' is not installed.
I tried -m but it doesn't help..
Any idea how to fix it?
Thanks,
T.
Hi
Just a brief question,
is there a way of displaying a success or not success message when running (testing) an SSIS package on SQL 2005 ?
Because i have to go through the steps to see if there was an error or not and for large SSIS packages this is a pain.
With DTS 2000 after it ran you got a message saying successfull or not, is there a way to activate this in SQL 2005 ?
I suppose i could just run the job ... but I prefer the other way as sometimes a job fail is a permissions problem, not a SQL/datapump task problem...
Hi,
I have been trying to install SQL 2005 Server Developer Edition 64-bit on Vista 64 all morning.
The setup refuses to install many components.
Has anyone gotten this to work?
jerry
I am having problems installing Sql Server Developer edition (2005) with VS 2005 and getting any ASP.NET projects to work.
It says SQl Server express must be installed.
I would like to use the full developer edition to link to my projects.
Can someone help?
Thanks,
Mike G
I would like to create an SSIS package in 2005 and run it in 2000. Is there anyway to do this? Or does SQL Server 2000 have a precursor to SSIS? I am trying to create a job to automatically catch and kill orphaned processes.
-Kyle
Sql 2005 Express with XPP SP2 and the latest MS updates sometimes runs very slow.
A SELECT which should take a fraction of a second can take several 10s of seconds.
I have checked autoclose is OFF for database using
use master
go
exec sp_dboption 'your_db_name','autoclose'
And it is definitely showing as OFF
I've looked at the Activity Monitor and when stalled it shows one or two processes for my database which are sleeping with 1 or 2 open transactions. When I look at their details they are simple select statements.
Often when my computer should be idle SqlServer.exe can be consuming 20 - 30% of cpu
I've noticed that I have TWO sqlservr.exe showing in my Task Manager, Processes display
One sqlservr.exe is 27K using about 17% even tho computer is idle has username NETWORK SERVICE
Other sqlservr.exe is 343K using 0% has user name SYSTEM
I don't know why.
Wayne
After going through "Add and Remove Programs" and removing all components of SQL Server 2005 Standard Edition on my desktop I get an error telling me there is a copy already installed and to remove it before continuing. Well nothing shows up under "Add and Remove Programs"; Windows cleanup shows none of the SQL Server components; a check of the register (HOTKEYS.../unistall) have no SQL Server entries; under services all SQL Server services are disabled and not running.
I have followed all the steps in http://support.microsoft.com/kb/909967 (Describes how to uninstall an instance of SQL Server 2005 manually).
Anyone out there got a solution? (Visual Studio 2005 eval is loaded on the box)
During customer engagement, I was told that there are Microsoft add-on to be installed on SQL 2005 and the SQL 2005 can be simulated as SQL 2000, SQL 2000 SP4, SQL 7.0 in different SQL instances.
Is this true? Are there URLs about this topic?
Thanks a lot.
Po-Shan.
My first question is can I run Analysis Services 2005 on a different server to where the databases are running
If yes, any pointers to some articles.
I have been trying to get Sql Server 2005 Express Advanced with SP2 installed and operating on my Vista machine. It seems to install ok but when I open Management Studio Express and try to create a new db or attach an existing one, I get error messages. So although it seems to be installed, I can't really use it.When I try to create a new database I get: TITLE: Microsoft SQL Server
Management Studio Express
------------------------------
Create failed for Database
'practice'.
(Microsoft.SqlServer.Express.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while
executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
CREATE DATABASE permission denied in
database 'master'. (Microsoft SQL Server, Error: 262)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
When I try to attach an existing database I get:
TITLE: Microsoft SQL Server
Management Studio Express
------------------------------
Failed to retrieve data for this
request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while
executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
The server principal
"Dave-PCDave" is not able to access the database "model"
under the current security context. (Microsoft SQL Server, Error: 916)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I have tried following the links in the error messages but the result is: "We're sorry
There
is no additional information about this issue in the Error and Event
Log Messages or Knowledge Base databases at this time. You can use the
links in the Support area to determine whether any additional
information might be available elsewhere."I am successfully using both programs on my XP SP2 machines, so I know how to install and run them on XP, just not on Vista (yet). Any suggestions on how to proceed?
Hi,
I have installed SQL 2005 and was trying to run one of the Samples. I installed SQL as an instance, but when I run the setup script, it fails because it can not assign permissions to the ASPNET account.
It looks like it thinks the account is ServerNameInstanceNameASPNET, but it should be ServerNameASPNET.
Thanks,
Michael Wassermann
I need some help, I am new to Microsoft SQL Server 2005 Integration Services and I am having some problems running Reporting Services ExecutionLog Package in Integration Services. After setting up and running the package, I received this warning message : "Truncation may occur due to inserting data from data flow column 'InstanceName' with a length of 38 to database column 'InstanceName' with a length of 32". I have modified the column length for 'InstanceName' from 32 to 38 in the affected table but I am still receiving this warning message : "The external metadata column collection is out of synchronization with the data source columns. The column 'InstanceName' needs to be updated in the external metadata column collection"
How do I update column 'InstanceName' in the external metadata column collection?
Where do I find the package steps logs (sysdtspackagelog or sysdtssteplog) when running the package as a job or manually.
Hello,
I have one program using MSDE as database. It runs OK on the machine with MSDE or without MSDE.
But it can not connect to MSDE database if PC with 'Microsoft SQL Server 2005' and 'Microsoft SQL Server Desktio Engine(MICROSOFTSMLBIZ)' installed.
Form SQL Server Server Manager: my instance ...MYINSTANCE and ...SQLEXPRESS are both running OK.
Why not connect to my MSDE instance under this situation? Could anyone give me any advice?
Thanks,
Dennis
I have a stored procedure in my asp.net 2.0 app that will not run. I am using an sqlcommand object and executenonquery. At first I received an error "execute permission denied". I had already given the user on sql server read and write permissions. So -- since I was not passing the sql server userloginid or password in the connection string, I tried changing the connection string in my web.config to:
"data source=xxxSQL2005;initial catalog=AdventureWorks; User Id=myid;password=mypasswd"
now I get an error that the login has failed for user xxx. So I am wondering what I need to do to run stored procedure in a web app. I am using the full sql server version not express.
Thanks for any help on this.
smHaig
Hello
We have 1 machine running SQL Server 2005 x64 (64 bit). The other machine is backing this SQL Server up. It is a 32-bit machine, so it requires (?) a 32-bit version of SQL Server 2005.
Would this back-up machine work correctly on a database previously managed by a 64-bit machine and vice versa.
Thank you!
I'm running 2000 databases in a 2005 server. Can anyone tell me if there are adverse effects in doing this?
As I understand it, the 2005 performance benefits are available to databases running as 2000(Ver80) But some of the new futures may not be available..
And any documentation from Microsoft/white papapers regarding this subjects are appreciated..
Is this supported on Windows 2003 sp2 and does anyone know how to do a silent install of this using Altiris?
Thanks!