Microsoft Sql Server 2000 Tools

Monday, November 30th, 2009

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 [...]

Sql Server Administration – my 8 Tips

Tuesday, November 17th, 2009

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 [...]

Sql Server 2000 Error – my 7 Tips

Friday, November 13th, 2009

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 [...]

Sql 2000 Server Download – my 8 Tips

Sunday, November 8th, 2009

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 [...]

Sql Server 2000

Sunday, November 8th, 2009

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 [...]

Sql Server Delete – my 7 Tips

Saturday, November 7th, 2009

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 [...]

Sql Server 2000 Backup – my 9 Tips

Thursday, November 5th, 2009

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 [...]

Sql Server 2000 Performance Tuning – My Tip

Thursday, November 5th, 2009

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 [...]

Sql Server Query – my 7 Tips

Tuesday, November 3rd, 2009

1) How To Use Sql Server Query Analyzer In My Home Pc ?

Hi, i wish to connect my vb with sql server in my home pc is there any option to do it ?

2) How Do I Do An SQL Server Query In Java?

After I connect to SQL Server using JDBC and Java, how do [...]

Microsoft Sql Server Reporting Services – my 8 Tips

Sunday, November 1st, 2009

1) How To Set Up Microsoft SQL Server 2005 With Reporting Services Correctly On A Windows Server 2003?

How to set up Microsoft SQL Server 2005 with Reporting Services correctly on a Windows Server 2003?
I encountered alot of problems setting up the SQL Server 2005 togehter with the reporting service. I am not using Active Directory [...]