• Setup SSIS for a group of developers.

    I newbie and I need help here. We are doing a new MS SQL and BI setup for our developers here. We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that the 12...

    Cnboon5 pointsBadges:
  • Halt audit trace if audit file doesn’t rollover

    I have a security requirement for SQL Server 2005 and 2008: "SQL Server shall be configured to halt if a failure in audit file rollover occurs". How do I accomplish this?

    VelameLaCosa110 pointsBadges:
  • SQL Server 2008 restore error

    error message : The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server....

    Kazem10 pointsBadges:
  • SQL Server 2008 Restore Fails – There is insufficient system memory in resource pool ‘internal’ to run this query

    I am trying to restore from a backup to a new database, and it processes for 8 hours and completes to 100%, and i get the following error. 100 percent processed. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Msg 701, Level 17, State 123, Line 1 There is...

    MTLONDON20 pointsBadges:
  • session error

    Just upgraded a vendor app from sql 2005 to sql 2008 r2 sp1 and are consistently getting Error: 18056, Severity: 20, State: 29. The client was unable to reuse a session with SPID 72, which had been reset for connection pooling. I have applied all patches and stil lcan't get rid of error. User's...

    tcstl95 pointsBadges:
  • SQL Server Data file Shrinking

    We have the database in SQL server 2008 and size is nearly 160 GB.We have configured Transactional Replication on this database(Only few tables).There are 50% of free space available on Datafile. To reduce the disk usage We try to shrink the datafile, but unfortunately the file does't shrunken.The...

    asenthil175 pointsBadges:
  • cluster install node failure when adding

    I installed a sql server 2008 cluster, first node went fine, however the 2nd node install fails with the following installing failover node sql server 2008 This resource does not have all the nodes of the cluster listed as 'Possible Owners'. The group that this resource is a member of will not be...

    tcstl95 pointsBadges:
  • Link SQL Server 2008 to AS400

    How to set up a ODBC for SQL 2008 to the AS400

    Jaymz69765 pointsBadges:
  • EmployeeNumber query in SQL Server 2008

    I am trying to write a query that will generate employee numbers. Employee number = first initial & first 7 characters of last name. UNLESS that is taken, then it's first initial, first 6 characters of last name, then the number 1. UNLESS that is taken, then it's first initial, first 6 characters...

    Mmdmurphy30 pointsBadges:
  • Increase in Network I/O when running SQL Profiler

    Hi, Just wondering why every time I run the profiler on SQL Server 2008, and I monitor the Activity Monitor's network I/O it increases and when I stop or pause the profiler the network I/O decreases? This occurs the same when I run the profiler remotely or on the SQL Server instance. What has this...

    Db23290 pointsBadges:
  • Problem Querying SQL table from PHP

    I recently added a new table to an existing database. Data is entered into the db via a web front end, using PHP 5. I am not a php developer. Our developer is trying to build a search query against the new table (there is data in the table). From the page he is working on, he can run a query...

    ELHaysStrom20 pointsBadges:
  • The SSIS 2008 R2 job does not complete execution

    I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP's some files to the local folder. I verified to confirm the files are downloaded correctly. 2....

    Iamhere98025 pointsBadges:
  • SQL processor license

    on a physical server we select 2 processors. we then select SQL 2008 STD 1 socket license. since the server has 2 processors, can we assign SQL to only processor and run? if we can, can the second processor on the server be used by the OS on the server?

    Enterprises5 pointsBadges:
  • SQL Server Data Files

    I have a production server with 10 databases, is it good practice to put all the log files for all 10 databases on one RAID 5?

    Rick Martinez585 pointsBadges:
  • How can I create reference key of non-unique column in SQL server 2008

    how i create refrence key of non-unique column in sql server 2008?

    V4apr5 pointsBadges:
  • SQL statement needed to remove characters

    I have data in one of my columns in a table that I would like to remove via a SQL update statement.  In all cases, the data that I want to remove is the same 3 characters at the end of the varchar field.   How would I structure the SQL statement?

    Satonthehill5 pointsBadges:
  • Oracle 10g to SQL Server 2008

    Our DB is Oracle 10g. Our Clients Test DB is SQL Server. Now sometimes, we do incremental loads, full loads or historic load. The present system what we have is we send the insert statements and the DDL to them and they create and load. I did not write it. It takes 40 hours. Under 1 scheme we have...

    Cholan5 pointsBadges:
  • Save high volume xml transactions to db

    I'm not a DB developer, I know basic select statements but that's about it. We have a high volume xml web service that takes roughly 200K transactions per day. Each transaction request has a corresponding response so that's about 400k transactional xmls per day to save. Each request xml is anywhere...

    GreenJello15 pointsBadges:
  • Email sp_who2 on lock/wait sql server 2008

    I have an alert set up to run a stored proc that will email me the results of a sp_who2 when the Lock Waits/sec rises above 2 seconds. The problem is that the alert doesn't fire off until after the lock has cleared, so the results of the sp_who2 are not very useful because they don't contain the...

    TJay85 pointsBadges:
  • SQL Server Fails to Start When Moved to Different Node

    Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the sql server...

    Spadasoe5,130 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