• Automation of SQL Report

    Hi, I need to automate a certain report which we take from 2 different databases and paste the data in the Excel and send it to certain email IDs? can someone help me??

    Ramesh63635 pointsBadges:
  • MSSQL service SQL service icon in the system tray does not have a green arrow on it

    I know Windows Sharepoint services with Windows Server 2000 installs SQL MSDE by default and the installation of same occurred successfully but how come afterwards the SQL service icon in the system tray does not have a green arrow on it instead it has a white filled-in circle and when I launch it...

    SAP Cum IT35 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sp_OACreate is missing

    Hi I'm trying to create a stored procedure to send mail, and 1 line in my SP states: EXEC @hr = sp_OACreate 'CDONTS.NewMail', @MailID OUT But I get an error that sp_OACreate is missing. How it happened I don't know. But how do I fix the problem? Is it possible to recreate sp_OACreate manually?...

    Kowalski5 pointsBadges:
  • Complications in snapshot replication from a SQL Server database

    I have done snapshot replication from my SQL Server database to another SQL Server database. After completing the replication, the replicated data is not present in the other SQL Server database. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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.

    Deepanshu35 pointsBadges:
  • 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...

    Jzurbo775 pointsBadges:
  • Stored Procedure

    I am calling some stored Procedure, having selct statment, after inserting some a new data entry by different stored procedure. Some times my Select stored procedure does not return any value. Data is exactly correct and when I explicitly called that SP with same data by Query analyzer, I will got...

    Deepanshu35 pointsBadges:
  • The purpose of an “undo” file in SQL Server

    I performed a full backup on a development database (Full Recovery Model) in SQL Server, made some changes, backed up the transaction logs, made some more changes and backed up the transaction logs again. Now, when I restore the database using WITH STANDBY, it puts the database into a read only...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating a database on two nodes in a SQL Cluster

    I have set up a SQL Cluster for three nodes, but I need to create a database on only two nodes. How would I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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)?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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 expired)"....

    Tito70475 pointsBadges:
  • 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.

    George5512505 pointsBadges:
  • Password policies for SQL Server 2005 (Yukon)

    What are the password policies within SQL Server 2005 (Yukon)?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating SQL databases for customer data

    I am creating an application that potentially has quite a lot of rows of data for hundreds of customers. Each set of customer data is only for that customer. There may be some future requirement to summarize the data for all customers, but that is not currently needed. Would it be better to place...

    SQL Server Ask the Experts2,585 pointsBadges:
  • VB.NET code ideas on a SQL Server

    What VB.NET code would I use to populate a ComboBox with all SQL Server names and IDs in a network? Also, what VB.NET code would I use to backup my SQL database using parameters?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it

    Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it? Hey i have Zip file which i want to extract using the sql script or using DTS Packages. and also want to run the Batch file from DTS Packge. its possible or not ? and yes then how ?

    21748165 pointsBadges:
  • 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 you Carla

    Cecrane10 pointsBadges:
  • RAID Levels on SAN

    When deploying SQL Server 2005 Enterprise whether it is 32-bit or 64-bit versions using a SAN backend, does the Storage Methodologies regarding RAID1 (VRAID1) or RAID5 (VRAID5) change? There are differences of opinions in our organization regarding this issue. From the DBA Standpoint we strive to...

    ROWENS07150 pointsBadges:
  • Identifying data in SQL Reporting Services

    I am using SQL Reporting Services, and one of the files has the same ID but a unique position number. The field names are ID, pos, phone number and extension. Now, for example, a person with three phone numbers will have three records (pos 1-3). In this scenario, how would I identify a phone number...

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following