• Storing attachments in tables on SQL Server 2005

    I am new on .NET and plan to migrate some applications to this new environment. I have a simple question – on SQL 2005, can you store attachments inside of tables?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Help with new installation of SAP CRM and supporting software

    We are going to Install SAP CRM 5.0 with Microsoft SQL Server 2005 and ECC 6.0 with Oracle 10g and integrate these with each other and also with QAS (Third Party tool). My question are: 1. Can we install all three applications on one single server as database is different or will there be issues...

    CRM Ask the Expert250 pointsBadges:
  • Data Sources for SSAS 2000

    I have a short term issue where I will need a SSAS2000 cube to be using data from a SQLServer2005 database. Can I do this directly? If not, can I Export MSSS2005 data directly to the MSSS2000 database? (Sorry for such a simple question- I am a newbie).

    Petro5 pointsBadges:
  • Table creation in SQL Server 2005

    Hi, I need to prevent users to use CREATE TABLE but I need them to be able to execute a stored procedure that creates a table. Is it possible to allow users to create tables in SQL Server 2005 only through a stored procedure? Thanks in advance.

    Alediamo10 pointsBadges:
  • SQL 2005 Transaction Logs

    I am by no means very good at SQL. I know the basics. I am a network engineer but was recently asked to do a few tasks in a SQL 2005 environment. I currently have a database that is residing off-site and I was asked to import the database and transaction logs so that this server can be used for...

    Danyluk15 pointsBadges:
  • Should we use system tables or information schema views to retrieve metadata if both give the same results? Please explain why.

    Should we use System tables or Information schema views to retrieve Metadata, since both give the same results, and why?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Need to upgrade sql server

    Hi right now my database server running on sql server 2000 & my application is also running from the same server for heavy load on server i m going to seperate my database server & application server i need a help bocz my database size is all most 3 GB. also i need to upgrade my database on new...

    Ravijoshi2020 pointsBadges:
  • how to upgrade server to SQL 2005

    I have a system with MS SQL Server 2005 installed and am running the MS SQL Server Management Studio Express but when I query the database version it comes back as SQL 2000 - 8.00.194. How do it change to using SQL 2005?

    Cjdechris5 pointsBadges:
  • Problem converting Access SQL query to T-SQL 2005

    I have a SQL Server 2005 database. One of my co-workers has put a MS Access front-end on it, because of the ease of designing queries in Access. I need to convert an existing query from Access SQL to T-SQL to put it into production. So far, I have removed all the obvious differences between the 2,...

    Chunkydrew15 pointsBadges:
  • Veritas vs. SQL Server 2005

    Why will SQL Server not accept files restored from Veritas backups?

    Patticake5 pointsBadges:
  • how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003

    Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local servers over...

    Sahaj5 pointsBadges:
  • Database Newbie

    Im quite new to database security and MSSQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with an open port but...

    Neutrino10 pointsBadges:
  • Sql server 2005 database filesize auto grow

    Hi i'm running sql server 2005 sp2 on a w2k cluster; i'm expericing this issue whereby the file size of a particular database will auto increase even though no one is even accessing it. Is there anyway to findout the cause of this issue or how can i stop the database from auto increasing the file...

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