Log shipping after upgrading to SQL Server 2005
I’ve upgraded our warm backup to SQL Server 2005 recently, but our log shipping is down. How can SQL Server 2005 be used with SQL Server 2000 log shipping?

Answer Question   |  November 11, 2008  7:06 PM
Log Shipping, SQL Server 2000, SQL Server 2000 Log Shipping, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server upgrades

Writing a query to store an image file in a SQL Server 2005 table
How would I write a query to store an image file in a SQL Server 2005 table?

Answer Question   |  November 11, 2008  7:02 PM
SQL Server 2005, SQL Server Query, SQL Server tables

SQL database backup
Am having 2 databases running on SQL SERVER 2000, OS(windows server 2003), so the backup for these databases are to suppose to run on monday, wednesday and friday 12:00 and 16:30 in the afternoons.So since last week the backups have been failing to run till today, and by checking the event viewer, this is waht [...]

Answer Question   |  November 12, 2008  8:45 AM
SQL Server 2000, SQL Server 2000 backup, SQL Server 2000 scheduled backup, SQL Server backup, SQL Server errors, Windows Server 2003

SQL Server trigger , insert result of multiple where clause into a variable
Hi All, I have a select statement that stores the result in a variable,this works fine if there is only one condition and field in the clause.How do I go about it if there is more than one? For example (Working one) SELECT @Variable = (SELECT [Field] FROM [Table] WHERE [FIELD] = Value) But I [...]

Answer Question   |  November 12, 2008  8:23 AM
SELECT statement, SQL, SQL variables, Triggers

Setting a username and password in SQL Server
How do I set the username and password in SQL Server to allow connection to the database?

Answer Question   |  November 10, 2008  7:37 PM
SQL Server, SQL Server administration, SQL Server authentication, SQL Server connectivity

Configuring the mail account in Database Mail
When I configure the mail account in Database Mail, does the @servername have to be a website address?

Answer Question   |  November 10, 2008  7:34 PM
Database Mail, SQL Server

Using the snapshot feature in SQL Server 2005 to replicate an operational database
We are trying to keep a replicated copy of a customer’s operational database at our hosting facility. Our copy of their operational system will be used to run ETL against each night to refresh a data reporting database. Our hope is that, each night, we will receive a snapshot file and apply that to our [...]

Answer Question   |  November 10, 2008  7:31 PM
Snapshot replication software, SQL Server 2005, SQL Server database, SQL Server replication

Obtaining the value of certain columns in a SQL database
I have created the following trigger that inserts data into a SQL table when a specific column is updated. I would also like to obtain the current value of certain columns of the updated row. To do this, I’ve been using the INSERT command, but I keep receiving NULL values in return. This is the [...]

Answer Question   |  November 10, 2008  7:27 PM
columns, SQL Server, SQL Server databases

Error messaging while using BCP in SQL Server 2005
I am getting this error while using the Bulk Copy Program (version 9.0) in SQL Server 2005: “An error occured while processing the command line”. I am using the following command: bcp MyDatabase..temptable in “C:Documents and SettingsRishiOut.txt” -c -r n -SMyServer -UHamp -Ppass123 >>Error.txt Why might this be?

Answer Question   |  November 10, 2008  7:24 PM
Bulk Copy Program, SQL Server 2005, SQL Server errors

SSIS package using dynamic configurations
Hi I have to create a package which process the analysis services cube and its partitions,and dimensions. This package should run every 15 minutes to process the cube. I have a procedure which creates the database in analysis services db and relational db for the current month. I have another procedure which creates daily tables [...]

Answer Question   |  November 10, 2008  5:28 PM
SQL Server Analysis Services, SSAS 2008, SSIS, SSIS Package 2008

Data retrieval from TextBox and insert in to database
Hi i am learning c#2008 and asp.net3.5. I want to get data from my textbox control and insert it in database so i cant find any source code or presentation so please tell me how to do it or give me site address where i can find this Thanks

Answer Question   |  April 15, 2010  10:33 AM
ASP.NET, ASP.NET 3.5, C#, C# 2008, Database connectivity, Database programming, SQL connectivity, SQL Server 2005, SQL Server 2005 connectivity, TextBox

Backing up SQL Server 2005
Where can I find information on backing up SQL Server 2005?

Answer Question   |  November 7, 2008  8:56 PM
SQL Server 2005, SQL Server backup

Outputting results of SQL SELECT statements into a spreadsheet
I am using OPENROWSET to output the result of a number of SQL SELECT statements into a spreadsheet. It works for most of the SELECT statements, but there are 4 random queries out of 82 that take more than an hour to execute. This is the code: insert into OPENROWSET(‘Microsoft.Jet.OLEDB.4.0′, ‘Excel 8.0;Database=D:MGTempESWIConvAuditQueriescnvWriteOff.xls;’, ‘SELECT Phone, Member, [...]

Answer Question   |  November 7, 2008  8:54 PM
OPENROWSET, SELECT statement, SQL Server, SQL Server Query

SQL 2005 trial version update
I installed SQL 2005 trial version on a production server and the 6 months are almost up. I would like to go to SQL 2008 since I can get a very good deal for it. What options do I have? Can I just upgrade over the trial version or I need to uninstall 2005 and [...]

Answer Question   |  November 10, 2008  7:13 PM
SQL, SQL 2005, SQL 2008, SQL Server Enterprise Edition, SQL Server upgrades

Configureing DTC in Windows 2008 64 bit clustering with SQL 2008 std 64 bit
I have read some limited blogs and kb articles about this DTC setup in windows 2008 clustering with SQL 2008. I like to get some clarification about this DTC setup. Our shop doesn’t use distributed transactions but we do use transactional replication. So our DTC is mostly used in SQL related process and I don’t [...]

Answer Question   |  November 10, 2008  6:05 PM
Clustering, Configure DTC in Windows 2008 with SQL 2008, Distributed Transaction Coordinator, DTC, Failover Cluster Management, SQL 2008, Windows Server 2008, Windows Server 2008 Clustering

Connecting to SQL Server 2005 after installing PowerBuilder
I have installed PowerBuilder 11.1 and I am trying to access SQL Server 2005 from my system. I use SQL Native Client for connecting to SQL Server 2005, but I am receiving the error, “Could not connect to Data Source”. However, I am able to connect to that server using ODBC and SQL Server Management [...]

Answer Question   |  August 10, 2010  3:41 PM
PowerBuilder, SQL Native Client, SQL Server 2005, SQL Server errors

Restoring to the end of a log backup in SQL Server bulk-logged recovery mode
In bulk-logged recovery mode in SQL Server, how can you restore to the end of a log backup that includes a bulk event? It seems to me that everything after the bulk event is useless. How could I do this?

Answer Question   |  November 7, 2008  3:39 PM
SQL Server backup and restore, SQL Server logs, SQL Server recovery

Writing a stored procedure to insert an ASP.net file into a SQL database
I need to write a stored procedure to insert into a SQL database the contents of a file that has been in read in ASP.net. How would I do this?

Answer Question   |  November 10, 2008  3:37 PM
ASP.NET, SQL Database, SQL Server stored procedures

Virtualizing a SQL Server cluster in a production environment
What is Microsoft’s official position in using virtualization (Virtual servers such as VMWare, etc.) for a SQL Server cluster (two node Active Passive) in a production environment? What are the best practices?

Answer Question   |  November 13, 2008  3:34 PM
SQL Server, SQL Server clustering, SQL Server Virtualization, Virtualization

Restoring a SQL database with an .mdf file
How can I restore a SQL database with an .mdf file?

Answer Question   |  May 5, 2012  3:32 PM
MDF, SQL Server database, SQL Server database restore