• Event ID: 2803 and 17137 Question

    I have recently installed SQL 2005 Express and Symantec Backup Exec for Windows 2003 SBS. I have not created any backup jobs and do not have an Active SQL DB just yet. However the following Information Events are being logged under Application Event every 5 minutes. Is this normal and is it...

    PCJunkie870 pointsBadges:
  • Can anyone tell me the best way to query Active Directory in SQL?

    Can anyone tell me the best way to query Active Directory in SQL? I'm using SQL Server Management Studio Express and want to add the LDAP server for AD as a linked server to query. I'm not sure what the best way to do this is.

    Eabouzeid175 pointsBadges:
  • SQL Writer error message – SQLDUMPER library failed

    error sql writer - sql dumper liabrary failed initialization install corrupt or tamper with

    Mmichals15 pointsBadges:
  • SQL Server 2005: Improving performance of Multiple Databases & LUNS

    I am looking at ways to improve performance of our databases. We have 4 large databases (ranging between 50gb and 200gb each) on a single SQL Server 2005 Cluster. Currently they are split 2 on one LUN and 2 on another. I am looking at ways to improve the IO performance of the databases as they are...

    Bulldog9815 pointsBadges:
  • Bulk Insert Problem in SQL Server Management Studio 2005

    Hi. I'm running into an issue performing a bulk insert. I've taken the following steps: Created a tableCreated a schema file with a .fmt extensionCreated a stored procedure to insert a file When I attempt the bulk insert I get the following error message: Cannot bulk load because the file...

    Eabouzeid175 pointsBadges:
  • Windows Scheduling iSeries Data Transfer

    I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe...

    Heather4000 pointsBadges:
  • SQL Query for Price Data of Different Stocks from 1 table with same dates

    I am having 1 table with date, stock and price data for all stocks. I want a sql query which will display the date, stockname1, stockname2, stockprice1 and stockprice2 for the 2 stocks I mention and the date range I mention and date should be common to both stocks. If stock1 has a price on lets say...

    Akshah10 pointsBadges:
  • SQL Server 2008 Management Studio evaluation edition a time bomb?

    Hi, I was just wondering if the Management Studio for SQL Server 2008 evaluation edition is also a time bomb? One of our client wants to just install the 2008 Management Studio and I was just wondering if we could use the Evaluation edition or do we have to purchase a license just to get the Client...

    Db23290 pointsBadges:
  • Backup storage for sql server 2005

    1.create database ABC 2.backup database ABC to disk='D:backupDBABC.bak' Here i created a new database 'ABC'.NOW my DATABASE is empty(no objects where created), i am taking full back up,the out put i am getting OUTPUT: Processed 152 pages for database 'ABC', file 'ABC' on file 1. Processed 2 pages...

    Buckup5 pointsBadges:
  • SQL Server table structure

    Hi, i want to know is there any command other than SP_help or SP_columns to see the STRUCTURE of TABLE.

    Tablestructure15 pointsBadges:
  • Compare Two Tables With Identical Fields

    Need to compare two tables A & B with identical fields and report when rows don't match and rows from B are missing in A.

    Jaggerdude60 pointsBadges:
  • Documentum Stops Processing

    During import of Excel files, documentum just stops processing & disappears. There's nothing in the log, other than 49 files were processed & no errors. EMC cannot duplicate the error in their lab. Installation gone awry? CC me at morgans@southcoastplaza.com with solution.

    CMSteven5 pointsBadges:
  • How to connect PowerBuilder 10 with Microsoft SQL Server?

    connect Powerbuilder 10 with Microsoft SQL??

    Matiusk5 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • SQL Query for Time Filed

    I have a sql table where the field tr_time contains the trade time and datatype of the filed is Datetime. I want to retrieve records where the time is in multiple of 5 seconds, so records where the seconds are in multiple of 5 only. How can I do this?

    Akshah10 pointsBadges:
  • To write a stored procedure

    there are two tables one ZipCode and one tempTable each has ZipCode and CongDist as columns. Each Zipcode has more than one CongressionalDistrict. How can I write a SP to have a seperate entry for each senario of Zipcode and Congressional District in tmp Table

    SProcedure25 pointsBadges:
  • SQL server query to search for table and column data in database

    I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column

    Linu438910 pointsBadges:
  • SP Dynamic SQL with LIKE Operator

    Hi. I want to create a stored procedure whereby the variable comes after the LIKE operator. For example, the code would look something like this: CREATE PROCEDURE SPFIND @VARIABLE1 VARCHAR SELECT * FROM TABLE1 WHERE FIELD1 LIKE '%@VARIABLE1%' Then to execute the procedure, EXEC SPFIND...

    Eabouzeid175 pointsBadges:
  • SQL indexes

    hello, there are many indexes clustered an non clustered .so how can i see the result of each index, clustered and non clustered seperately through (T-SQL) pls guide me. RINO

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • SQL Server partitioning

    Hello Sir, i m creating a partition  as  use master go create database mypartpracdb214 on primary (name=db_dat, filename='c:partitionpracticedb.mdf',size=4mb), --filegroup fgi --(name=fgi_dat,filename='cpartitionpracticefgi.mdf',Size=2mb), filegroup fg2...

    Fhhdjfhjdhfjhjdfh135 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