Saving the results of a SQL Server 2005 table query in a XML file
I have data in a table on a SQL Server 2005, and I need to query this table and save the results in a XML file that conforms to a given XSD. Is there an easy way of doing this?
View Answer
| Jul 23 2008 5:08 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Query, SQL queries
export sql server 2005 to dbf
I have problem with exporting a table to a dbf format file in sql server 2005Has anyone done it before? Thanks!
View Answer
| Jul 22 2008 2:16 PM GMT
| asked by
Ellie
SQL Server 2005
How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.
How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.
View Answer
| Jul 19 2008 6:06 AM GMT
| asked by
Deepanshu
SSIS, SQL Mail, SQL Server 2005
CASE sintaxis error in SELECT
In the middle of a large storage procedure I have a working SELECT 01 (see below) which at a couple of points uses CASE statement.I need to expand the most inner CASE to get SQL Server check for several values instead of one. Currently CASE I am talking about looks like (it is in the middle of...
View Answer
| Jul 18 2008 7:46 PM GMT
| asked by
Jzurbo77
CASE statement, SELECT, SQL Server 2005
Error in the installation of SQL Server 2005 (64-bit)
We are trying to upgrade our installation to SQL Server 2005 (64-Bit) Edition, but we cannot get past the following error reported in the Event Log:***********************************Event Type: ErrorEvent Source: MsiInstallerEvent Category: NoneEvent...
View Answer
| Jul 18 2008 6:45 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005 (64-bit), Event log errors, SQL Server 2005
SQL Server
What is a tempDB in SQL Server?
View Answer
| Jul 18 2008 8:50 AM GMT
| asked by
Sai
Windows XP, Visual Studio 2005, SQL Server 2005
Password policies for SQL Server 2005 (Yukon)
What are the password policies within SQL Server 2005 (Yukon)?
View Answer
| Jul 17 2008 4:44 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Yukon, SQL Server permissions
How do I write the code to connect an .aspx webform to a MS SQL server and database
This was done in VS 2008 the web forms are registration and log in forms with aspx controls. I created the database and the tables ( but am having issues with the constraints for 3 columns). I am trying to find out how to connect the 2 and where would I put the code. I am not a programmer and I am...
View Answer
| Jul 17 2008 1:47 PM GMT
| asked by
Twinkles rules
Server errorlog, SQL Server errors, VS 2008
SQL Server 2005 Reporting Services (Web Service)
I have installed SQL Server 2005 reporting services, its works fine but the web service is not working. my web service is running under network service and its as priviledge to run. When i browse it after a few minutes it says page cannot be displayed. Any help would be appreciated.
Answer Question
| Jul 16 2008 8:48 PM GMT
| asked by
George551250
SQL Server Reporting Services, SQL Server 2005, SQL Anywhere Studio
Running a lengthy query on SQL Server 2005
We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it took 12 hours. Why would this be?
View Answer
| Jul 16 2008 8:21 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Query, Windows Server 2003
SQL Server 2005 Maintenance Plans - overwrite vs. append
I am trying to create a maintenance plan, but when I use the backup database widget, it defaults to 'append existing...'. I want 'oversrite existing...'. Can anyone help me find where that is set?Thank youCarla
View Answer
| Jul 16 2008 3:50 PM GMT
| asked by
Cecrane
SQL Server administration, SQL Server 2005
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?
View Answer
| Jul 15 2008 8:28 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Query, SQL queries
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
View Answer
| Jul 14 2008 6:37 PM GMT
| asked by
1 letters
SQL Server 2005, Active Directory, 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!
View Answer
| Jul 14 2008 6:22 PM GMT
| asked by
Jean.young
Memory, Database, 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 0x80004005 (Login timeout...
View Answer
| Jul 14 2008 3:26 PM GMT
| asked by
Tito7047
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)?
View Answer
| Jul 14 2008 1:51 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Data Types, NVARCHAR
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.
View Answer
| Jul 11 2008 7:22 AM GMT
| asked by
Karanam
SQL Server 2005, .NET application, Database connectivity
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?
View Answer
| Jul 10 2008 5:48 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Query, SQL queries
Converting data field into hours, minutes, seconds.
How do I convert a field in SQL 2005 from seconds to hours, minutes, and seconds?
View Answer
| Jul 10 2008 4:18 PM GMT
| asked by
Tonya
T/SQL, SQL Server 2005
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 join takes...
Answer Question
| Jul 10 2008 1:50 PM GMT
| asked by
Dpaproskijr
SQL Server 2005, SQL Server errors
