Microsoft Sql Server 2000
Jul 20, 2005
i wanted to restore user DB from one sql server to another sql server ,
one database is having so many table and have user called digi
he is created so many SP and some tables., when i restore the db it
restored without any problem.,
after restoring application is not working
how to ensure that restored DB is having same security as the original
for that user .
when i tried to run the script of that db over that restored DB
it was showing user digi does not exist. but i have creted user digi
where can i get the useful information about this
/sreeni
--
srin
Posted via http://dbforums.com
View 1 Replies
ADVERTISEMENT
Feb 17, 2004
My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer.
I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm).
When I try to run setup, I get that message that says:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."
Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up?
I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks!
Ron
View 3 Replies
View Related
Feb 16, 2006
venu writes "Hi,
Am very new to MS SQL adminstration
Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.
The activity which am going to workout on MSDE is below.
How to install SQL(on XP)
How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other)
How to create/delete tables if so, how can we do it either by GUI or CUI
just i need a clarifications reg same
Thank you,
venu"
View 1 Replies
View Related
Apr 26, 2006
asif writes "sir i have microsoft server 2000
and i have to use taht in my pc only
i have instaled taht in my pc but when i run sql query analyser then its asking for database and many more please solve my problem.
i am using windows xp service pack2
so please help me
"
View 2 Replies
View Related
Jan 31, 2006
Greeetings!
I am newbie in SQL, asking help from you people.
We are using Microsoft SQL Server 2000 Service Pack 2 running on Windows 2000. We are planning to update service pack from to 2 to SP4...Is it okay? What are the requirements? Will there be side effects in our systems?
Hope to hear from you soon.
Regards,
Len
View 1 Replies
View Related
May 7, 2004
I'm unable to gain connectivity to two stand- alone PC's having WIN XP PROFESSIONAL, v. 2002, through Microsoft SQL SERVER 2000. :eek:
Both the PC's are stand-alone and have both have WIN XP PROF. I installed Microsoft SQL SERVER 2000 in which only the Client Components were successfully installed.
I have the Administrator Rights on both the PC's.
The Problem on both the PC's that I'm facing is as follows:-
On starting SQL Server Enterprise Manager, the PC was not detected as a Server under the SQL Server Group, and thus I selected the option 'New SQL Server Registration', then I gave my full computer name (as appears in the properties of 'my computer'), selected Windows Authentication and then selected OK to start or connect.
It did not connect and then I got the following error message:
-------------------------------------------
A connection could not be established to 'COMPUTER NAME'.
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())
Please verify SQL Server is running and check your SQL Server registration property (by right click on the COMPUTER NAME_node) and try again.
OK
-------------------------------------------
On starting the SQL Query Analyzer, firstly the message connecting to 'COMPUTER NAME' was seen and then it also gave the following error message:
-------------------------------------------
Unable to connect to server 'COMPUTER NAME':
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][Shared Memory] SQL Server does not exist or access denied.
OK
-------------------------------------------
where the 'COMPUTER NAME' stands for the name of the particular system that can be seen in System Properties-> Computer Name-> Full computer name.
I had installed the MDAC Components from the Windows Update website.
I checked the registration properties and have tried many times but everytime the same error messages were received in both the systems and all the efforts bore no fruits.
Both the systems are:
Intel P4
WINXP PROF. v2002
128MB DDR RAM
40 GB HDD
Please help soon as I am studying SQL Server!
THANKS. ;)
View 14 Replies
View Related
Jul 31, 2006
Hi
I never use Microsoft SQL Server .. somebody told me to start with 2000 version .. but I know that there is 2005
I want to know if it is ok to start with 2000 version and at the same time i can follow others who use 2005?
Thanks
View 4 Replies
View Related
Sep 19, 2006
Hello,
I would like to see if Microsoft has issued any announcement on SQL Server 2000 end of support. If anyone is aware of this or seen new posts/articles, please let me know.
Thank you!
View 3 Replies
View Related
Dec 17, 2005
Hi all,
I'm new to this forum, though not new to sql server am new to DB2.
We are running Microsoft SQL Server 2000 but we have recently acquired similar business in another country which runs IBM DB2 database system. We are interested in incorporating the data from DB2 in our system. The tables are slightly different in DB2.
Q. what is the best way to integrate the two systems? Should we take the route of a federated system or replication of data?
We are interested in knowing what is happening in the other business (DB2) but we what the two systems to operate in parallel for about a year, before we come up with the best solution.
The company is after a short term and long term solution.
Can any one please help or point me to the right place?
Regards,
Chloe.
View 2 Replies
View Related
Jan 29, 2004
Trying to install Microsoft SQL Server 2000 Desktop Engine on my laptop. I downloaded the software and opened it to a folder on the C drive. Then from the command prompt I entered this:
C:msderela>setup sapwd = hillary instancename=mjh targetdir=c:mike
The program starts to install and seems to get near to the end of instal and then the progress bar starts going backwards and nothing gets installed....any ideas of what I'm doing wrong....I really don't know anything about this at all.
Thanks
View 14 Replies
View Related
Feb 13, 2006
I'm working towards MCAD and as elective I want to do the SQL Server course. The exam is on SQL Server 2000. I was just wondering whether the online course that Microsoft currently have a available for free at https://www.microsoftelearning.com/sqlserver2005/default.aspx would be useful and applicable to SQL Server 2000, or whether it is sufficiently different product to make it confusing to use this as a learning resource.
Also if anyone can point me toward any webcasts for SQL Server that would be great. I listened to Fritz Onion's 15 part series when I studied for my ASP.NET exam and would like to do something similar for SQL Server 2000 if any are available.
View 3 Replies
View Related
Oct 7, 2005
Ok so i am thinking of get the Microsoft SQL server 2000 Developer Edition, i have some questions. - Does it include the server and tools?- What tools does it include? The same as the Enterprise Version?- Will it positively work on Windows XP Pro?- Will you need to install anything else? Does it come with the Microsoft Server Desktop Edition as the server or something?- Will this version allow me to use it to make databases for websites? I searched this forums but i can seem to find what "....it is prohitbited in production..." that means?Thank you and i have tried to search the forums but have gotten no real answers Hope you can read my questions clearly. Thanks!!!!
View 4 Replies
View Related
Apr 9, 2001
I recently wrote a white paper on OLAP and was having a hard time finding any information about what was new in SQL Server 2000 OLAP on the web. I didn't really find much until I downloaded a trial copy of SQL Server 2000 (which didn't have OLAP, but had links to information on it). We use Hyperion Essbase, and I was wondering if Microsoft OLAP 2000 would be a viable competitor.
View 2 Replies
View Related
Nov 17, 2006
Microsoft SQL Server 2000 DTS Designer Components has cause a total destruction of my Enterprise Manager.
In my workstation I've got Sql Server 2000 client and Sql Server 2005 client. Everything goes fine up to here.
But when I've installed that MSI I have not been able to open my Enterprise Manager.
From MMC appears: Error initializing component CLSID: {xxx.xxx}
My goal was be able to open 2000 stuff from Sql Management Studio. By the moment, I'm forget of that.
Does anyone have ever faced this issue?
QA is working.
Thanks in advance for any suggestion
View 6 Replies
View Related
Apr 17, 2007
Hi all,
This may be more of a Sharepoint or server question but I thought I would post it here to start off with. I have an installation of SQL 2000 SP4 and sharepoint services 2003 all on one server. For example the SQL 2000 (SP4), sharepoint and its indexes all on the one server (HP G4 DL380). I have installed the index service and the full text services on the SQL server then configured searching in sharepoint. The search worked fine for about a year until one day the server started randomly hanging for no apparent reason. After a hard reboot the server would begin to hand again after around 2-3 minutes of being online, sometimes less. After lots of problem shooting I nailed it down to being the Microsoft search service that caused the issue. Basically if I set this service to manual and boot I have no problem. As soon as I start the service the server will start to hang about 2-3 minutes later.
I tried this again last night after trying some fixed and got the same result. The only error I get are in the application log which are about 4 of these with different file types.
One or more documents stored in image columns with extension €œX€? did not get full-text indexed because loading the filter failed with error '0x1'
The server continues to log messages while it is hanging and you can ping the server but you can not access sharepoint, remote in to the server, you can login locally but as soon as you try anything like bring up the start menu all resources will freeze up. During this time there is no disk activity and the CPU usage is 1-3% and mem usage is low.
Can anyone suggest anything to fix this problem so I can start the Microsoft search service and use search in sharepoint again.
Thanks,
LS
View 2 Replies
View Related
Feb 27, 2006
Is there a X64 version of Microsoft SQL Server 2000 DTS Designer Components from Feature pack for SQL Server 2005?
I have installed an X86 version on the AMD64 machine. But when I open a sql 2000 dts package, there is always a warning window.
The Message is as follows:
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.LegacyActionBase.CreateLegacyDesigner()
at Microsoft.SqlServer.Dts.ObjectExplorerUI.OpenLegacyPackageAction.Act(INodeInformation nodeInfo)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.DtsServerMenuItem.Invoke(INodeInformation parent, String mode, String assembly, String type)
There are two same assemblys called 'Microsoft.SqlServer.DtsObjectExplorerUI' in the GAC, and one is GAC cache type, the other is zap cache type.
View 4 Replies
View Related
Nov 16, 2006
Hello Friends,
I have a problem with ASP.net with dynamic data transfer from asp page to microsoft sql server 2000. For example , I have asp
web page with one text field and a buttion.
When I click the buttion, the value entered in the text field should be transfered from the text field to database.
Kindly See the following section c# code .....
SqlConnection objconnect = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = objconnect;
cmd.CommandText = " select * from Table_Age where Age = @Age";
cmd.CommandType = CommandType.Text;
SqlParameter parameter = new SqlParameter();
parameter.ParameterName = "@Age";
parameter.SqlDbType = SqlDbType.VarChar;
parameter.Direction = ParameterDirection.Output;
parameter.Value = TextBox1.Text;
objconnect.Open(); // Add the parameter to the Parameters collection.
cmd.Parameters.Add(parameter);
SqlDataReader reader = cmd.ExecuteReader();
********************this section c# code is entered under the button control************************************
connection string is mentioned in the web.config file.
In the above c# code , I have a text field , where I entered the age , the value entered in the text field should be sent to
database. I have used SqlParameter for selecting the type of data should be sent from ASP.NET 2.0 to the microsoft sql server 2000. I am facing a problem
where I am unable to sent the random datas from a text field to the database server.
I have a created a database file in the microsoft server 2000.after the excution of the fIeld value is assinged to NULL in the main database i.e microsoft the sql server 2000.Can anyone help with this issue.My mail id phijop@hotmail.com- PHIJO MATHEW PHILIP.
View 1 Replies
View Related
Jul 20, 2005
HI!I have a little problem:I have change the administrator password (Windows 2003 Server) which MSSQL 2000 use to login.And now the SQL server can't stand up.What should I do?thx!gicio--Posted via http://dbforums.com
View 1 Replies
View Related
Jan 25, 2007
Currently a server running 2003 small business operating system has MSDE 2000 and Microsoft##SSEE.
A memory problem exists with SQL consuming over 50% of RAM. Total RAM is 4GB.
There is a SQL 2000 patch for this type of problem. However, it calls for SQL to be upgraded to SP4.
Problem:
Can this MSDE 2000 be upgraded with SP4 and have memory patch applied with Microsoft##SSEE also on this box?
Please let me know. Thank you.
View 3 Replies
View Related
Jun 21, 2007
Hi
I am trying to use Association Viewer Control in
Microsoft.AnalysisServices.Viewers.DLL dll in VS 2005 but sometimes it gives an error.
"Code generatio for property 'ConnecitonManager'" failed. Error was:'Property accesor 'ConnectionManager' on object 'AssosiactionViewer1' threw the following exception:'Object referance not set to instance of an object"
Is there anyone here who use
"Microsoft SQL Server 2005 Datamining Viewer Controls" in SQLServer2005 FeaturePack ?
http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
i am using VS2005 Version 8.0.50727.762 (SP.050727-7600)
and SQL Server 2005 SP2
thanks from now.
Cem Ãœney
View 9 Replies
View Related
Jul 23, 2005
Dear All,Access adp on sql-server 2000After upgrating to A2003 updating data with 1 perticular combobox causes theprogram to hangs without any error-msg.Traying to change te combobox recordsource i get this error:This version of Microsoft Access doesn't support design changes to theversion of Microsoft SQL Server your project is connected to. See theMicrosoft Office Update Web site for the latest information and downloads(on the Help menu, click Office on the Web). Your design changes will not besaved.The solution in :http://support.microsoft.com/defaul...kb;en-us;313298tolks about SP 'dt_verstamp007' but I have SP 'dt_verstamp006'What should I do.Is the failure of the combobox also caused by the absence of dt_verstamp007???Filip
View 2 Replies
View Related
Sep 25, 2007
Hi,
I'm trying to install Microsoft Dynamics 10.0 with SQL 2008 Dev but when launching the utilities this returns the following error message:
******************************************************************
Your current SQL Server is not a supported version.
Req: Microsoft SQL Server 8.0
Act: Microsoft SQL Server code name "Katmai" (CTP) - 10
You need to upgrade to SQL Server 8.0 before continuing.
******************************************************************
Any ideas could help or has this if anyone knows been desinged not to work with GP10 currently?
Assad
View 7 Replies
View Related
Mar 17, 2008
I have a query that executes just fine except that it won't recognize varchar(255) ( or any other value within the () ) and if I leave it off like this: varchar, then it executes but it leaves that value as 1 and that is just not very useful for my purposes. This also happens with anything else that requires () to add length such as char(), or nvarchar(), etc... Any ideas?
View 1 Replies
View Related
Oct 3, 2001
Hello,
"Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server "
I keep getting this when trying to copy stored procs from one db to another on the same server. I am using the DTS wizard. I have been able to copy the tables but I need the sp's too, and there are too many to copy one at a time.
Help!
TIA,
Bruce
View 1 Replies
View Related
Mar 27, 2008
Pls tell me about the adjact difference between sql server 2005 and sql server 2008.
Why to upgrade for Sql Server 2008
View 1 Replies
View Related
Aug 30, 2006
In VS 2005, when we choose database connection, we can choose one of the above. My question is in what situations should we choose MS SQL Server Database File (SqlClient), and when should we choose Microsoft SQL Server?
I want to deploy a standalone desktop application with a backend database. Which backend database should I should and which of the above connection should I choose?
Thanks very much for your information.
View 1 Replies
View Related
Dec 10, 2003
Hi Everybody,
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application.
--------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
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: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
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:
[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.]
Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838
Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
View 5 Replies
View Related
Sep 12, 2007
Hi
We are checking VB 9 (Orcas).
we connected to database created under with sql server 7. with this code
Public cn As New ADODB.Connection
Public Sub OpenDB()
cn.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial catalog=Reservation;Data Source=.")
End Sub
this code worked well.
we know sql7 is not compatiable with vista. please tell us how to connect it wiith sql2005 . we downloaded orcas express edition beta. we created a database also. please let u know how to connect with Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5).
Rgds
Pramod
View 7 Replies
View Related
Jun 18, 2004
Hi,
I'm trying to slove this problem from last few hours. I cannot slove this problem. Getting following error message if i try to login in Microsoft SQL Server 2000. Programming in Visual Studio NET -> MFC...
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
CDBVariant value;
CDatabase db;
char sql_statement [2048] = "";
//CDatabase object "db" created to connect database
db.OpenEx(_T("DSN=MQIS"),CDatabase::noOdbcDialog);
.
.
.
.
can someone please help me out, is something wrong with the code ??
View 8 Replies
View Related
Nov 19, 2004
Just wonder how many of you are using or had used indexed view in SQL 2000? Please, share any details/info.
We are currently using in and having problems as we are getting Errors 644, 'Couldn't find index...' every time we try to update the underlying tables.
View 2 Replies
View Related
Aug 26, 2006
hello all member
View 14 Replies
View Related
Jul 23, 2005
I'm not asking a lot. I just want to know if I can connect from anExchange server to a SQl server without having to use Access linkedtables. Surely MS must have had a look at this but I can't findanything out there.Help appreciated.Ginters
View 1 Replies
View Related
Mar 27, 2007
Does Microsoft officially support installing SQL 2005 Express on a server where SQL 2000 Enterprise Edition is already running (a has to keep running).
In case they do, where do i find this official info / note.
Have they released white papers on this matter?
I know it is possible to install the two together and that they can coexist, but I am worried about how the two SQL installations wil behave when being updated with patches, security updates, service packs etc. do you run the possibility of them corrupting each other? Therefor it is vital to know if Microsoft supports the two running on the same system.
View 3 Replies
View Related
