Writing a specific query in SQL Server 2005
I have a table called “ticketing” and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?

Answer Question   |  July 16, 2008  8:28 PM
Query, SQL Query, SQL Server 2005

Creating View With Xml file and table in sql server 2005
Hi, I have an Active Directory Xml File and I have archived Table with Active Directory With Limited Information like(GUI,FName, Userid) I like to create a view By left join active directory file and archived table. Thanks for reply in advance Please reply to this question

Answer Question   |  July 14, 2008  6:37 PM
Active Directory, SQL Server 2005, XML

How to manage memory for SQL 2005 x64 on 64-bit WS2003 Ent
I have a Windows 2003 Enterprise 64-bit server running SQL 2005 x64 with 32GB RAM. The SQL database is acting as a transaction database. What is the best way to manage memory on this server? Should I adjust the paging file? If so, to what? Any ideas are appreciated!

Answer Question   |  July 14, 2008  6:22 PM
Database, Memory, Server management, SQL Server 2005, Windows Server 2003

SQLServer2005 CopyDatabase Wizard error
Using the CopyDatabase wizard to copy from one SQLServer2005 server to a new SQLServer2005 server node, I got an error in the <Configure the Package> step, that says: “While trying to find a folder on SQL an OLE DB error was encountered with error code 0×80004005 (Login timeout expired)”. Please tell me how I can [...]

Answer Question   |  July 18, 2008  3:26 PM
CopyDatabase Wizard, SQL Server 2005

Converting the nvarchar datatype in SQL Server 2005
SQL Server 2005 automatically converts all the fields with the nvarchar datatype to nvarchar(MAX), which I can’t use with formula functions in Crystal Reports. Is there a way to stop this conversion to nvarchar(MAX)?

Answer Question   |  July 18, 2008  1:51 PM
Crystal Reports, Data Types, NVARCHAR, SQL Server 2005

Not able to coonect to SQL Server 2005 from Front End in windows Vista Home Basic
Im not able to connect to SQl Server 2005 installed in my local PC to .net application.But im able to open SQL server 2005 seperatley & able to create tables.Im getting connection failed error while trying to connect.Please give slution for this.

Answer Question   |  July 11, 2008  7:22 AM
.NET applications, Database connectivity, SQL Server 2005

Toggling a case sensitive query in SQL Server 2005
It appears that my queries of stored procedures, tables, columns, etc. are case sensitive in SQL Server 2005. Is there a “case sensitive” option that I can toggle on and off?

Answer Question   |  July 10, 2008  5:48 PM
Query, SQL Query, SQL Server 2005

Converting data field into hours, minutes, seconds.
How do I convert a field in SQL 2005 from seconds to hours, minutes, and seconds?

Answer Question   |  July 29, 2008  4:18 PM
SQL Server 2005, T/SQL

slow outer join after delete rows
Hi, I’ve tried this on two installations of SQL Server 2005 service pack 2. If I delete rows of a table, an outer join on the empty table is extremely slow…if I truncate it’s ok, if I delete with the tablock hint it’s ok. Any ideas why? The code to reproduce this follows, the outer [...]

Answer Question   |  September 9, 2008  1:50 PM
SQL Server 2005, SQL Server errors

Refusal to recognize SQL Server 2005 Express on a client PC
I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that [...]

Answer Question   |  July 8, 2008  3:45 PM
Access 2003, Microsoft Access, SQL Server 2005, SQL Server Express

installation of sql server 2005 in vmware
I am trying to install sql server 2005 in vmware with scripts but failed. Script is running successfully, but nothing is shown in sql server configuratin manager.

Answer Question   |  May 25, 2011  9:42 AM
SQL Server 2005, SQL Server Configuration Manager, VMware

unable to attach sample database in SQL 2005
Hi, I installed SQL server 2000 and SQL 2000 SP4. Than I installed SQL Server 2005. But when I am trying to attach the AdventureWorks Sample database, I am getting the following error: TITLE: Microsoft SQL Server Management Studio —————————— An error occurred when attaching the database(s). Click the hyperlink in the Message column for [...]

Answer Question   |  July 7, 2008  9:51 PM
Microsoft SQL Server Management Studio, Microsoft.SqlServer.Smo, SQL Server 2005

i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??
i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

Answer Question   |  July 8, 2008  5:55 PM
Software maintenance, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB, Visual Basic 6

SQL Server 2005 within MS Access VBA
I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code [...]

Answer Question   |  July 3, 2008  3:44 PM
Microsoft Access, SQL Database, SQL Server 2005

Including a primary key in a nonclustered index in SQL Server 2005
The query optimizer for SQL Server 2005 is suggesting that we include a primary key as part of a nonclustered index. Is it OK to include that to increase SQL performance?

Answer Question   |  July 2, 2008  5:36 PM
Index, Primary keys, SQL performance, SQL Server 2005

Network Redeisgn
Hi, I am serving as a system admin for an organization. We have ISA 2004 network, with Exchange 2003 Standard edition server, 2 Microsoft SQL server 2005 Standard edition for database projects, Windows 2003 domain controller in two sites A and B using active directory services. These two sites are VPN tunneled between ISA 2004 [...]

Answer Question   |  July 2, 2008  11:23 AM
Cisco 1700, Exchange 2003, ISA Server 2004, Network design, Network performance, Networking, PePLink 300, SonicWALL, SonicWALL TZ 170, SQL Server 2005, VPN, Windows Server 2003

Finding the total size of databases on SQL Server 2000 and SQL Server 2005
Is there a quick way to find the total size of each database on SQL Server 2000 and SQL Server 2005? I have tried running “sp_spaceused”, but I do not want to run it manually for each database. Do you have any ideas?

Answer Question   |  July 1, 2008  8:09 PM
Database, SQL Server 2000, SQL Server 2005

Sorting hierachy data alphabetically in SQL Server 2005
I have a follow-up question to the article Navigate hierarchies using recursive common table expressions. I have an employee hierarchy that follows a similar pattern to the article, but I need to be able to sort my data alphabetically within each level. Do you have any advice on how to accomplish this?

Answer Question   |  September 9, 2008  8:02 PM
Hierarchy data, Sorting, SQL Server 2005

Migrating data from Oracle 9i Database to SQL Server 2005
I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?

Answer Question   |  July 30, 2008  3:29 PM
Data migration, Oracle 9i, SQL Server 2005, SSIS, SSMA

Unable to Restore Backup in SQL Server 2005
I am unable to RESTORE Backup through code in SQL Server 2005 from VB.Net, even though that code is running fine in SQL Server 2000. The code is: “restore database [” + databasename + “] from disk =’” + Me.lblSource.Text + “‘ with move ‘” & dfile & “‘ to ‘” + Me.lbldatafile.Text + “‘,” [...]

Answer Question   |  September 20, 2008  7:35 PM
SQL Server 2000, SQL Server 2005, SQL Server backup, VB.NET