• 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:
  • 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,055 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...

    ToddN20006,360 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:
  • 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:
  • SQL Server Data File Storage

    We have a SQL Server with 32GB of RAM, 8 CPU 16 Cores, using SAN. On our production database (1 database only) we have 3 file groups Primary, Core, Index with 1 file in the PRIMARY Group, 16 Files in the Core Group, and 16 Files in the Index Group. Each file group including all data...

    Rick Martinez585 pointsBadges:
  • Combining 2 queries in SQL 2008

    I am having a little trouble combining the following 2 queries into a single nested statement (if indeed it's possible). Can anyone assist? Query 1: SELECT Eff_Date, CoNum, Brandname, COUNT(Brandname) AS CountOfBrandName FROM dbo.Products WHERE (Eff_Date BETWEEN '1/1/2010' AND '12/31/2010') GROUP...

    DavidHa!!110 pointsBadges:
  • Implementing a chat using SQLServer Service Broker – how good an idea it is?

    We are designing a chat engine. That's basically a message queue. When our customers will adopt it, there will be thousands of people chatting. In our company we use SQLServer heavily, and this is an argument for preferring Service Broker over MSMQ. Is Service Broker a good idea? Each chat session...

    Marcofaustinelli5 pointsBadges:
  • Cross-database name change in SQL Server 2008 stored procedures

    Hi: The easy part is the databases will be on the same server.  However at the moment I am writing code in database SOMEDATABASE_TEST which is accessing objects in SOMEOTHERDATABASE_TEST.  When its time to go to production the names are going to change to SOMEDATABASE and SOMEOTHERDATABASE. ...

    Rusty25 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