SQL Server 2005 log shipping network pass thru security
I have a need to ship logs to a remote secondary server that is in a different domain and without domain trusts. I have configured the SQL Agent on each machine to use a local account (.SQLAgent) with the passwords the same on both machine. The secondary machine can read the network share that contains [...]

Answer Question   |  March 18, 2009  2:16 AM
SQL Pass Through Query, SQL Server 2005, SQL Server 2005 log shipping, SQL Server Agent, SQL Server log shipping

SQL Export to Excel file column?
I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance

Answer Question   |  April 4, 2009  1:13 AM
Microsoft Excel, SQL Export to Excel, SSIS, SSIS 2005, SSIS Package 2005

SQL Server 2005 Select Multiple views or Tables
in SQL 2000 it was easy to cntl-right-click and select multiple views, stored procedures or tables and generate one script which could be changed (using SQL Analyzer) to create new objects (search and replace text) with different names. This was a big time saver but I don’t know how to do that in SQL 2005. [...]

Answer Question   |  March 18, 2009  12:07 AM
SQL 2005, SQL Multiple Views, SQL Query Analyzer, SQL Server 2005, SQL tables

table row values for column headers
Hi. I have two tables in a simple database: Prices ID (int, identity, PK) Year (smallint – year of value) Quarter (smallint – year quarter 1-4) Area (smallint – FK to Areas.ID) Index (float) Areas ID (int, identity, PK) Name (varchar) So, as you can see, the Prices table contains price information over time for [...]

Answer Question   |  March 19, 2009  7:25 PM
SQL, SQL Database, SQL tables

SQL Server 2005 SP3 installation on Vista – error message
A user recently submitted this question via e-mail: This Program has known compatibility issues. Check Online to see if solutions are available from the Microsoft website. If solutions are found, Windows will automatically display a website that lists steps you can take. Program: Visual Studio 2005 Publisher: Microsoft Visual Studio 2005 has a known compatibility [...]

Answer Question   |  March 17, 2009  7:25 PM
SQL Server 2005, SQL Server 2005 SP3, SQL Server on Vista, SQL Server upgrades, Vista

inserting null record in SQLServer2005 SSMEI through ASP.Net
I’m developing my 1st website but when I’m trying to insert data into the SQLServer 2005 it inserting null record. I tried as it is on access. again their is a same problem. Here is my code: Imports System.IO Imports System.Data Imports System.Data.Sql Imports System.Data.SqlClient Public Class contactus Inherits System.Web.UI.Page Protected Sub submit_ServerClick(ByVal sender As [...]

Answer Question   |  March 17, 2009  5:01 PM
SQL Server 2005, SQL Server database

How to perform pit recovery
I cannot find a good doc which describes hot to perform a pit recovery in sql server.

Answer Question   |  March 24, 2009  2:18 PM
Pit Recovery, SQL Server Pit Recovery, SQL Server recovery

SQL Server 2008: SSIS pakage with parameters
I need to create SSIS package with user entered date parameter. I have two questions: 1. How I can promt the parameter when I test the package in debyg mode. 2. How can I put on the begining of the package design condition: Global Variable gvar_Date datetime; If @p_Date is null Then gvar_Date = getdate() [...]

Answer Question   |  March 17, 2009  8:43 PM
SQL Server 2008, SSIS Package, SSIS Package 2008

Using the return value of a SQL Restore script
I am trying to use the return value of a SQL Restore script executed with SQLCMD, so that my batch script can report on the succes or failure of the restore. I am having difficulty getting the script to return the result of the backup or restore process. Do you have any suggestions? The follwoing [...]

Answer Question   |  March 20, 2009  5:34 PM
SQL Restore, SQL Server, SQLCMD

Unable to correctly view overlapping SQL Server tables
I want to overlap two SQL Server tables, and when I do, it is visible in Report Preview. When I run the report in a browser, however, the second table starts only when the first ends. Also, when I view them as a PDF, they show properly. Any ideas?

Answer Question   |  March 16, 2009  5:32 PM
SQL Server, SQL Server Report View, SQL Server tables

Attaching a SQL Server 2005 database to SQL Server 2000
How can i attach a database created in SQL Server 2005 to SQL Server 2000?

Answer Question   |  March 16, 2009  5:25 PM
SQL Server 2000, SQL Server 2005, SQL Server 2005 Database, SQL Server databases

Finding a table’s name from a trigger name in SQL Server
How can I find the related table’s name from just a trigger name?

Answer Question   |  March 16, 2009  5:19 PM
SQL Server, SQL Server tables, SQL Server triggers

Storing and retrieving an image in SQL Server 2000
How do I store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end?

Answer Question   |  March 23, 2009  5:17 PM
SQL Server 2000, SQL Server Image Store, Visual Basic 6.0

Error while referencing external assembly in SQL Server 2005.
Sir, I created a dll (SqlWcfServiceLibrary1.dll) using .net frammework 2008. My code has a reference of another assemble (WcfServiceLibrary1.dll) also. I want to create assemble in sql and use that assemble in a procedure. I am getting error that “Error while referencing external assembly“. I am pasting all code that I used…. .cs page code [...]

Answer Question   |  March 22, 2009  9:47 AM
.NET Framework 3.5, Database programming, SQL Server 2005, SQL Server development, Visual Studio 2008, WCFServiceLibrary

SQL relational database
A relational database contains the following tables: Employee (EmployeeNo, EmployeeName, DateOfBirth, JobDescription,DeptNo) Project (ProjectNo, ProjectName, Location)Assignment (EmployeeNo, ProjectNo, Role-in-Project)Formulate the following using SQL:i. Find the names of all employees assigned to a project. List the employee names in an alphabetical order.

Answer Question   |  March 17, 2009  10:08 PM
SQL queries, SQL relational database

SQL View performance vs. SELECT
I am experiencing slow views on my database. If I create a view and run it, then use the same select statement from the view and run. They both return the same data, but View runs slower. My expectations was that since views are compiled, they should run faster. Could some one clearify this for [...]

Answer Question   |  June 8, 2010  7:22 AM
SELECT statement, SQL Server performance, SQL Server views

SQL Server replication fails after renaming Subscriber database
Running SQL Server 2005 on Windows Server 2003. Can the subscriber database to my publication be renamed? Experimented with renaming a test database but replication failed. Thanks. Moderator Note: This is a user submitted question

Answer Question   |  March 14, 2009  6:08 PM
SQL Server 2005, SQL Server 2005 replication, SQL Server Publisher/Subscriber, SQL Server replication, Windows Server 2003

Possible to deploy 2005 report to sql 2000 RS?
I’ve never needed to do this before, but I need to know if I can deploy a report built with VS 2005 to a SQL 2000 Reporting Services box. I don’t have an environment at the moment to test it on. Does anyone know if this is possible? Thank you in advance, tley

Answer Question   |  March 16, 2009  4:41 PM
SQL Server 2000, SQL Server Reports, SSRS, SSRS 2000, Visual Studio, Visual Studio 2005, VS 2005

Using SSIS to populate SQL Server Data Warehouse
I am just wondering if anyone has tried using SSIS to extract data from iseries tables to insert into Sql Server tables?

Answer Question   |  March 12, 2009  2:33 PM
AS/400 tables, SQL Server tables, SSIS

Reporting and Mirrored SQL2005 DB
Can i access the sql2005 mirrored db via crystal reports for reporting

Answer Question   |  March 10, 2009  8:04 PM
Crystal Reports, SQL 2005, SQL 2005 Database, SQL Database, SQL Server Database Mirroring