Can I use Microsoft SQL Server 2000 Personal Edition as a stand alone server?
I have a low-transaction system, and I wanted to put SQL Server 2000 personal edition on an XP Pro box as a stand alone system and have other systems on the network look to this box for its database. I’ve read [...]
I have made a database in sql server 2000 but didnot backup,?
I have made a database in sql server 2000 but didnot backup, later i have to uninstall the sql server and reinstall it. I have the .mdf and .ldf files, can i restore these files in my new sql server. I need it. [...]
Can anyone help with a microsoft access to SQL server transfer?
I am trying to bring a database from microsoft access 2007 into SQL server express enterprise 2000. So far I have done moved the data through the SQL server button in Access in the database tools tab. But there is one problem: one of the [...]
1) Sql Server 2005 Web Administration Tool?
I am looking for a SQL Server 2005 administration tool that I can use over the internet. Anyone got any sites?
I am actually looking for a Web Administration site for SQL Server 2005. Like something that uses IIS.
EMS SQL Manager 2005 Lite for SQL Server works (see link to [...]
1) Sql Server 2000 Error?
No connection could be made because the target machine actively refused it. I got this error after re-opening the ASP.NET AJAX-Enabled Web Site and tried connecting to the database. It does not have this error for other ASP.NET Websites. But if I create a new ASP.NET AJAX-Enabled Web Site and do [...]
1) Where Can I Get The Microsoft Sql Server 2000 Free Download?
From where can i get the microsoft sql server 2000 free downloads. i’ve searched in net but i couldnt get the proper site to download it.
many sites are giving only updtes for the older version.
From which site can i get proper download of the [...]
There are numerous types of parameters but some of the most useful to know are:
1: Selecting All or One item from a list
and
2: Selecting The Year and Month or Year, Month and Week.
The more you plan your reporting system, the less reports you need to write and the less you need to modify.
One reporitng system [...]
1) Can I Connect From Microsoft Access To SQL Server And Delete Records?
Can I connect from microsoft access to SQL server and delete records?
Yes, you can.
Use command in File/External data… menu.
2) How To Use Triggers To Update A Table In Sql Server Instead Of Delete ?
logically-delete a row in a table, rather than being actually [...]
1) How To Create Backup Copy Of Sql Server 2000 On Different Machine?
in windows server 2000/2003 we create additional domain controller on different machines , so that if one machine goes down another machine will handle job.
in the same manner i want to create backup copy of sql server 2000 on different machines in LAN.
so [...]
1) The Same Microsoft® SQL Server⢠2000 Database Engine Operates On Microsoft Windows® 2000 Professional, Microso
The same Microsoft® SQL Server⢠2000 database engine operates on Microsoft Windows® 2000 Professional, Microsoft Windows 2000 Server, Microsoft Windows 2000 Advanced Server, Windows 98, and Windows Millennium Edition. It also runs on all editions of Microsoft Windows NT® version [...]