• Can SQL 2008 R2 run on Windows 7 ultimate 64-bits

    Can someone tell me if SQL 2008 R2 can run on a Windows 7 Ultimate 64-bits?

    rosewambugu5 pointsBadges:
  • SQL Server Replication – Error 22022

    We have setup a database in one domain that needs to be replicated to another domain. we have a Metro E connection are able to access data from both databases. We have established the same username and password within SQL and AD for both domains. We have setup a publisher on Domain A but cannot get...

    cmessinger5 pointsBadges:
  • SQL 2008 Security: How do I give users access to just views within a DB?

    I have inherited a SQL DB and need to give a group of users access to some views within a DB. We do not want them to access the tables, just the views. They will be connecting using MS Excel for reporting purposes. Do I use a role or schema? What is the best practice to accompish this task without...

    Multipass5 pointsBadges:
  • In place upgrade from SQL 2008 R2 DEV to SQL 2012 SQL

    I have been working with SQL Server for many iterations and from the old days I remember the mantra “Do NOT do an in-place upgrade.” I'm about to upgrade from 2008 R2 DEV and TEST systems to SQL Server 2012 using the same hardware. I want to do it this way so that I don’t have to reconfigure...

    ITKE346,080 pointsBadges:
  • Free IT Book: Microsoft Windows 7 Administrator’s Reference

    This week's IT book giveaway is for the Microsoft Windows 7 Administrator's Reference: Upgrading, Deploying, Managing, and Securing Windows 7. Interested? All you need to do is answer one of the questions below and post the link to your answer in the discussion area of this question. JavaScript...

    MelanieYarbrough6,345 pointsBadges:
  • MSDTC promoting a transaction only in some environments

    We have a service which uses LINGTOSQL to process some updates on a remote SQL box.  On some machines everything is fine and it works without DTC enabled.  On other machines, that appear identical the transaction is being elevated to a distributed transaction and failing if it hasn't been enabled...

    Bee1075 pointsBadges:
  • How to read MS SQL tables using iSeries RPG

    Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?

    WoodEngineer6,650 pointsBadges:
  • Getting DB2 data into SQL 2008 database

    We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged to...

    ToddN200011,050 pointsBadges:
  • SQL query

    I have 3 columns: development no,city, status for stamp (this column is set by 0,1,2). I want to write a query that specifies percentage of stamps per city; for example percentage of stamps with 1 in city x, percentage of stamps with 2 in city x, percentage of stamps with 1 in city y....and so on....

    hengameh5 pointsBadges:
  • SQL server backup sqlvdi.dll not loaded into SQL memory

    We have receiving SQLVDI.dll error when we try to take the SQL backup on EMC Networker.We checked the sqlvdi status as suggested in http://archive.msdn.microsoft.com/sqlbackupsim . But we have the status in simulator that [em]"VDI dll not loaded into SQL Memory yet" .[/em]We register the vdi dll...

    asenthil175 pointsBadges:
  • SQL 2008 R2 ‘Web Assistant procedures’

    exec sp_configure 'Web Assistant procedures' When I execute above statement in SQL 2008 R2, I get the follwing error message Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51 The configuration option 'Web Assistant procedures' does not exist, or it may be an advanced option. How to...

    As6185 pointsBadges:
  • MSSQL 2008 sudden and drastical slow down – IT telephony

    Hi, I'm a newbie, greeting everybody from Hungary, and thanks for your time :) Generally the SQL system runs smoothly. There is a SP which runs two times daily, and it logs the begin/end times. It takes about 20 minutes each time, normally. Suddenly I see that it takes 3-4 hours. Each time the same...

    Sandy6015 pointsBadges:
  • SQL 2008 query: return results where row not in another table

    hi, running sql2008.  i have the following two temp tables.  the first is just all web service errors for a date range.  the second is simply 20 rows that contain values of types of web service errors. --temp tbl #1 select [date],[err],[srv],[e1],[e2] into #tblExcept from netlog where [err] like...

    RdS1995 pointsBadges:
  • problem in connect visual studio 2010 to SQL 2008

    when i am connecting the sql in my visual studio windows application to open a database file a error occurred you don't have the permission to open this file   contact the file owner or administrator to obtain the permission

    Prsaini5 pointsBadges:
  • 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:
  • Replication and run backups

    I am running SQL 2008 with replication between 2 locations. Will the running of backups impact the replication process. Can I run both on the same database?

    mf125 pointsBadges:
  • Link SQL Server 2008 to AS400

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

    Jaymz69765 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:
  • How to move sql server clustered instance to a separate stand alone server

    We are in the process of moving our Production instance and databases. Would be of nice help if anyone could shed their thoughts on How to move sql server clustered instance to a seperate stand alone server (along with system and user databases). We are stopping the cluster, moving the drives to a...

    Sqlserver2008r25 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