Archive for May, 2008

Sql Server Express Limitations

Saturday, May 31st, 2008

The primary query language is SQL Server Transact-SQL, an application of the ANSI / ISO standard Structured Query Language (SQL) used by SQL Server Express and Sybase. SQL Server is commonly used by companies to small and medium sized databases, but in the last five years have seen greater adoption of database products of [...]

microsoft sql express 2005 management studio download

Saturday, May 31st, 2008

microsoft sql high availability

Thursday, May 29th, 2008

High Availability Software: everRun from Marathon Technologies

Microsoft SQL Server 2000 High Availability

$3.74

SQL SVR 2000 HIGH AVAILABILITY…

Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring

$19.46

Create a Highly Available Microsoft SQL Server 2008 Environment Written by the technical director for SQL Server Magazine, this expert [...]

Sql Server Update Select Statement

Thursday, May 29th, 2008

The monitor lets you see the actual SQL calls made through SQL connection to a remote server, or by adopting a data source ODBC ODBC.
To open the SQL Monitor
Choose the database | SQL Monitor.
You can choose to track different types of activities. Select Options | Options to open [...]

microsoft sql autonumber

Thursday, May 29th, 2008

Sql Server Mirroring

Thursday, May 29th, 2008

DOTNUTSHELL Technologies is a database company with experience in design, with the qualification of Oracle services in both accredicated Company and OpenSource.
Microsoft SQL Server is a relational database management. Its primary query language is Transact-SQL, an application of ANSI / ISO standard Structured Query Language (SQL) used by Microsoft and Sybase.
[...]

Sql Server Insert Datetime

Monday, May 26th, 2008

hopfeed_template=”";
hopfeed_align=”LEFT”;
hopfeed_type=”IFRAME”;
hopfeed_affiliate_tid=”sql”;
hopfeed_affiliate=”ghebrillic”;
hopfeed_fill_slots=”false”;
hopfeed_height=280;
hopfeed_width=336;
hopfeed_cellpadding=5;
hopfeed_rows=3;
hopfeed_cols=1;
hopfeed_font=”Verdana, Arial, Helvetica, Sans Serif”;
hopfeed_font_size=”9pt”;
hopfeed_font_color=”#000000″;
hopfeed_border_color=”#FFFFFF”;
hopfeed_link_font_color=”#3300FF”;
hopfeed_link_font_hover_color=”#3300FF”;
hopfeed_background_color=”#FFFFFF”;
hopfeed_keywords=”Sql+Server+Insert+Datetime”;
hopfeed_path=”http://ghebrillic.hopfeed.com”;
hopfeed_link_target=”_blank”;

Sql Server Odbc Drivers

Monday, May 26th, 2008

Microsoft Dynamics GP Integration Manager module is very simple, especially when the input data is prepared and structured in CSV or tab-text Tab-delimited file. The same result if data is ODBC compliant and you can easily map to the destination. However, very often you find yourself in a situation where you can not control the [...]

Sql Server Functions List

Sunday, May 25th, 2008

Using C #, how can I get a list of databases on a MySQL server?
If you use an ODBC connection and can connect and interact server fine. I was completely unable to find a way to get a list of available databases. GetSchema function is only returning "views" as a result. Anyone have any [...]

Sql Server 2005 Management Studio

Sunday, May 25th, 2008

SQL Server 2005: SQL Server Integration Services Distribution package

Introduction
A decent amount of material has been the subject of this series of introduction to SQL Server 2005 Integration Services. Many features basic data stream is covered with some maintenance of databases. It's time to put these techniques in use.
[...]