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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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