• grid view connection to a data in a table ?!

    Hello , I'm julien , beginner in visual studio 2008 using c# language I Have this task that I seem to be stuck in ! I've created a database using sql server express 2005 of 4 tables :"BOOKS , AUTHORS , CATEGORIES and PUBLISHERS ". I've connected this database to my gridview in visual studio , it...

    Julien5110 pointsBadges:
  • trying to restore a database in SQL Server 7

    I know I have seen a simular question before but I did not get the exact answer I was looking for. I have created a backup of my database in SQL server 7. To my knowledge I just backuped a single databse at a time. The databases might be connected in that data is used between them, but basically it...

    EdwardL20095 pointsBadges:
  • Insert Word document into SSRS

    How can I import/insert a word document into a report in SSRS?

    NTBC5 pointsBadges:
  • Transaction Log – SQL Server 2005

    How do i find out what transaction log file was last applied to a database?

    0 pointsBadges:
  • How well does SSAS run under virtualization? Any special considerations?

    How well does SSAS run under virtualization? Any special considerations?

    ITKE346,360 pointsBadges:
  • SQL script to disable views after a demo period.

    Hi, I have a sql view that I created for someone on a test basis. I want to create something (stored procedure, trigger, etc) that will delete or disable this view after a 30 day trial period. I prefer to make the view unvisible even to the "sa" administrator so that the view can not be recreated...

    Katiekat5 pointsBadges:
  • Prevent unauthorized users from accessing SQL Server 2000

    One of the SQL Server 2000 databases that I administer is configured for Windows authentication. I added an integrated logon for the domain user group. However, 20 of those in the domain user group who should not have access to the server are still able to access it. How can I prevent these...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal Reports Duplicating Records

    Hi, I hope that someone can help me. We are currently replacing a system with a new version and as such we are building a new SQL DB. Although the two DBs store the same information they don't share a common layout. I have created a basic report to see if the record count for a certain select...

    Simonlevey5 pointsBadges:
  • when i print a work order in the application i need to update a field in a sql table to true

    when i print a work order in the application i need to update a field in a sql workorder table to true

    Tanjaatbrenlo40 pointsBadges:
  • What backend works best with Cognos frontend?

    Our company is looking to install Cognos as an upgrade from the Access reporting system we currently use. What is the best backend database to a Cognos frontend? We are considering SQL Server, but aren't sure if that is the best option. Any suggestions?

    Jayne46245 pointsBadges:
  • Retrieving System information

    I need to retrieve logins and users for all databases by server for SS2000 - 08. Querying the system tables sysservers, sysdatabases, sysloginns and sysusers provide the information. But how do I collect all that information with one query hopefully that I can run against all serves in the...

    Calcindor5 pointsBadges:
  • Are there any specific considerations we should be aware of as we attempt to migrate applications to a Hyper-V virtualized machines?

    We have major applications (Exchange 2007 and SQL 2005) that we have in a mission critical configurations “clustered.” Are there any specific considerations we should be aware of as we attempt to migrate these applications to a Hyper-V virtualized machines? Are there any resources available...

    ITKE346,360 pointsBadges:
  • Virtual machine failover

    So in a failover from a failed node, no data is lost there is just a longer interruption in service compared to live migration. Does the guest know anything happened or does it continue on as if nothing happened? Anything special for a virtual SQL or Exchange server in a failover scenario?

    ITKE346,360 pointsBadges:
  • Capitalize First Character

    How can ensure that when certain columns in a row are INSERTed/UPDATEd, the first letter of the value is capitalized and the rest are lower case? For example "QUESTION" or "question" should be converted to "Question".

    VelameLaCosa110 pointsBadges:
  • SSRS 2008 – Connection to Oracle 10g seems to be timing out

    I'm running SSRS 2008 via Visual Studio on my desktop. The data source for my report is an Oracle 10g database. The report runs fine when the parameters are set to limit the number of rows returned, but when I change them to return more data it eventually times out. The same query runs in less than...

    Jeffkopsa20 pointsBadges:
  • SSRS Excel Reports

    Hi, I have exported my ssrs report to excel.Everything seems to be fine regarding the alginment of columns etc. However, additional row or two appears colored below the complete table of the report. Can u please help me on removing this??

    Souras5 pointsBadges:
  • Changing UNC paths

    I have 138 rows of Universal Naming Convention (UNC) paths. Part of each path is constant and part is a variable. How do I change the constant portion of the UNC path and keep the variable intact? For example: •\serverpathdir1dir11 •\serverpathdir2 •\serverpathdir3dir31 constant part...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SSRS 2000 Support Ending Date

    Is there a data set when SSRS 2000 will no longer be supported?

    Stoptherain5 pointsBadges:
  • FirstIAM page of a table in SQL Server 2005

    Hi, Can you please explain how is the "FirstIAM page of a table" is calculated in the sysindex view, in SQL server 2005. Is is stored in some system table or is it calculated every time a table is accessed? Pardon me if this sounds to be a stupid question.I am new to SQL server 2005 :-)

    JudeAj5 pointsBadges:
  • Moving .MDF files from SQL Server 2000 to 2005

    Is it possible to just copy and paste .MDF files from SQL Server 2000 to 2005 instead of going through the whole migration process? My company doesn’t have the time that a full migration requires, so we are thinking about just keeping the files and pasting them once we have SQL Server 2005...

    SQL Server Ask the Experts2,585 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