Dear Experts,
Following 3 things I am doing in SQL Server 2000, How do I do the samething in SQL Server 2005 ?
Que 1)
In SQL Server 2000,Open enterprise manager and go to SQL ServerGroup.
Tree ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21936484.html
Hi,
I am trying to restore the master database in sql server 2005. I am brining it over from another database on another machine.
It is asking me to restore by using sql server in single use...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22115032.html
Hi experts,
I've just bought a SQL Server 2005 developer license to upgrade from Sql Server Express and now my connection is no longer working, i've tried all sorts of variations and have tried ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2241...
I need a Microsoft SQL Server 2005 stored procedure to be able to query a Microsoft Access 2003 table stored in an .mdb file on a Windows Network file share.
Is there anyway to do this? I Goog...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2246...
I have installed SQL Server Express 2005 database on my Windows 2003 server. It is being used on a website. I understand that SQL server Express has a size limit of 4GB. I got this information from...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2246...
I am building a new server to replace an older one that runs our primary homegrown business application. This server currently runs Windows 2003 Server Enterprise with SQL 2000. We will be moving t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2248...
SQL Server 2005 disk/memory performance.
OS: Windows 2003 Server (32)
Memory installed: 3,6 GB
Pagefile location: C:
Pagefile minimum: 2 GB
Pagefile maximum: 4 GB
SQL Databasefiles on sepe...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2248...
In SQL Server 2005 i have a table that contains two columns - FirstName and LastName.
I want to create a function that checks the LastName field (it contains multiple name surnames) and extract th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2253...
I have a table in SQL Server 2005 named "ItemCodes". There is a column named "Codes" in the table with data type char(8).
The data in this column can be of length from 1 to 8, for e.g. the data c...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2253...
I just bought a new laptop with Vista Business (ThinkPad T60). I am unable to completely install SQL Server 2005 Developer edition. I've tried 3 time - each time uninstalling everything that sa...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2255...