• Read Only access to a SQL Database? Best way?

    We're trying to prevent hacks on our site. We've been down several times and the idea came up that we could prevent the SQL Injections by making an account for just the public-facing side of the site that has Read Only set for it. This is a Microsoft SQL 2000 server BTW. Our hosting company...

    Kwoodall10 pointsBadges:
  • Oracle 10g on Windows 2003 virtual server

    We have installed a SQL server on Windows 2003 virtual server and there were performance issues. Will oracle 10g make a significant difference in terms of performance? Are there known issues concerning 10g DB running on Microsoft 2003 virtual server? thanks

    Markv5 pointsBadges:
  • Utility to Compare Security Configuration Between Database

    We are trying to restore a SQL Server 2005 database from a production to a QA environment. We are using certificate security, multiple schemas and certificate signed stored procedures. We need to find a utility which can tell us security configuration differences between the two environments. Any...

    Aiguy5 pointsBadges:
  • SQLServer equivalent to dba_role_privs, dba_user_privs, dba_object_privs ???

    Is there a SQLServer equivalent to being able to retrieve internal application specific metadata that to the users/roles v.s. object privs (select, insert, update, delete, execute, etc.) ? In oracle it's achieved by forming SQL selecting data from the appropriate "dba_" views. In SqlServer this can...

    DaveSTC0 pointsBadges:
  • Using xp_cmdshell

    Hi, I am using xp_cmdshell in one of my stored procedures(database SQL server) to delete older files from a folder in another server. That server is mapped as a network drive on the sql server computer. But when I used this drive inside xp_cmdshell command and do a dir , the output I get is 'Access...

    Gullu15 pointsBadges:
  • sql server reporting server

    I have seperate application server for ASP.NET(2.0) and Database server for Sql RS 2000, when i try calling reporting service webservice to generate excel and allow to download to the web user, it gives an error as "401 as unauthorised", can anybody has a solution for this Regards, Prathesh

    Prathesh5 pointsBadges:
  • Suspect DB

    Hi, I am using sql server 2000 and recently found 2 of the DBs are marked as Suspect and I don't have access to them any more.Would you please help me with this? Thanks, Ellie

    Ellie145 pointsBadges:
  • How to perform exploratory database testing using ERDs

    Can you please advise me on how to perform exploratory testing on a database using ERDs?

    SQL Server Ask the Experts2,585 pointsBadges:
  • disk activity is running at 100%

    24 hrs ago disk i/o and activity shot up to 100* with quues grwoing. our average i/o queue is normally around zero with disk activity at <15% we have had this before - lasts a couple of days and then stops. we have never found out why? can anyone help?

    Salmonthefish5 pointsBadges:
  • After exporting charts from SQL Server Reporting Services to MS Excel, images appear poor

    I have a problem with my charts. After exporting from SQL Server Reporting Services to Excel, my charts look "ugly.” Quality is low, images are blurry, etc. Is it possible to change settings somewhere?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!

    Hello Community If you haven't noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and...

    ITKE56,505 pointsBadges:
  • Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

    Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to transfer data from two servers of GIS to one server of sql server?

    How to transfer GIS data from two servers into one server of SQL server , is it possible? and if so then what tool should i use? could anyone please help me in this plzzz :-(

    Obaid10 pointsBadges:
  • LAZY WRITER Process

    Hi, We have Database production server with following configuration: Model: HP DL 585 G5 RAM: 64 GB Processors: Intel Xeon (R) CPU E7320 @ 2.13 GHz (16 processors) OS: Windows 2003 Server R2, SP2 SQL Server 2005 with SP2 LAZY WRITER 16 Process is running continuously, daily we will have to restart...

    63075 pointsBadges:
  • i want to change the true bits to false and vice versa

    i have a table where i have true and false bits..i need to replace the true bits to false and vise versa

    Sam535 pointsBadges:
  • HOw do I restore a database from a backup in MS SQL Server 2000

    I have no knowledge of MS SQL Server. Have software (BOOMI) that uses a database in this. I found a folder where the database is being backed up. i.e. there is a *.BAK file and hourly logs *.TRN. I need to update the boomi software and they say I need to make a back up of the database. If this is...

    Arlocoder50 pointsBadges:
  • Flush the query plan from the RAM.

    Our clients are reporting that the sql server is slowing down over a period of time. Once the SQL Server is restarted everything is fine.SQL server slowing down over a period of time though has technical reasons. SQL server caches (in memory) the queries that are sent it to, expecting to reuse it...

    MNA20 pointsBadges:
  • SQL and Moss 2007 from Jameel Ur Rahman (Abbottabad)

    hi, I recently done Moss 2007 certification . an di want to know the relation of SQL and Moss 2007 , and also let me know for Moss 2007 implemention how i prepaer my self regarding SQL because SQ L new for me any book or white paper that help me and also SQL 2005 Administration thanks jameel

    Jameelrk5 pointsBadges:
  • jobs runing on the server

    hi every 1, i am having a real tough time to figure this one out . i need to find out what jobs are schedule in the server that sends data out to ever . we are doing the migration from 2000 to 2005 and need to know which jobs send data to the another server . i looked at the sysjobs_view , it tells...

    deal11deal110 pointsBadges:
  • Connect to Sybase ASE 15 via MS SQL 2005

    I'm in a test phase and would like to connect to a Sybase ASE 15 server in much the same way as linking tables in access. How would I accomplish that?

    Bhassel25 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