• 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:
  • Copy SQL Server Table

    How do I copy a table into the same database without including the data? Thanks ken

    Ilfoprog50 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:
  • SQL Server

    What is a tempDB in SQL Server?

    Sai5 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:
  • Implementing access from a remote site to a SQL Server 2000 database

    I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have any...

    SQL Server Ask the Experts2,585 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:
  • Catching an uncaptured error in SQL

    This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught'...

    SQL Server Ask the Experts2,585 pointsBadges:
  • failure to register an SPN

    Event Type: Information Event Source: MSSQLSERVER Event Category: (2) Event ID: 26037 Date: 07/07/2008 Time: 07:37:40 User: N/A Computer: Computer name Description: The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098,...

    Tiz5 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