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

    ITKE350,840 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:
  • Migrate an Oracle database to SQL2005

    I need to migrate an Oracle database to SQL2005. How many users have done this and what tool did you use? How effective was it? I know Microsoft has a migration tool, but just want to cover my bases as this is a very high profile project. Thanks all!!

    mnman66265 pointsBadges:
  • how to get list of encrypted objets in sqlserver 2005?

    i need a list of encrypted store procedure name,encrypted trigger ,encrypted functions from sql server 2005.

    Subrata735 pointsBadges:
  • Home Network Configuration SQL Express 2005

    Hello, I am pretty new to Sql. I had setup a SQL Express 2005 Advanced on a computer w/ xp on it before and had no problems. I recently purchased a installed a new computer (the other one died) w/ Windows Vista. As before, I downloaded and configured Sql Express per instructions for the software...

    Ddog06295 pointsBadges:
  • Scheduling a DTS Package

    Hi On MS Windows Server 2003 I have a DTS Package in SQL Server Enterprise Manager. The DTS package runs fine in SQL Server Enterprise Manager. How do I add that DTS package as a scheduled task? Thanks P

    Pmwhelan5 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