• Transaction log for read only database…

    Hello there, I am currently studying for the 70-432 (MCTS SQL Server 2008 I&M) exam and I am using Microsoft 70-432 Training Kit by Mike Hotek. At some point the book claims "when a database is placed in READ_ONLY mode, SQL SERVER removes any transaction log that is specified for the database....

    Dallasfb15 pointsBadges:
  • Unable to backup sql database.

    the full error that I am receiving is Backup- \\usfshk3ap09.edcllc.net\D: DataAn unknown or unexpected database error occurred while attempting a DBCC. The file name "C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_Config.mdf " is too long to create an alternate stream name.

    Terrywilson40 pointsBadges:
  • Upgrading Microsoft SQL 2000 to SQL 2005

    I have one server running SQL Server 2005 and about five servers running SQL 2000. Does anyone know what is entailed as far as upgrading from SQL 2000 to SQL 2005? The majority of the servers are running Win2k Server.

    Mr D50 pointsBadges:
  • How to use DateDiff to calculate costs?

    Hi, In my Access bookings system you select a number of Units and a start and end booking time. I need to calculate the cost of each Unit for the booking as well as a total cost for all Units in the booking. The information is stored in two tables: a bookings table called tblHourPeriod with the...

    Dontgetit105 pointsBadges:
  • EMC networker MSSQL Restore hangs

    I am trying to restore the model database on a EMC MSSQLv5.1 client The EMC server is version 7.4.2 When running the restore we can see no activity on the Client and in the Networker console it shows the server as "browsing". In the devices tab no tapes are loading and nothing is reading from...

    Shaun536910 pointsBadges:
  • Deadlocks and Conflicting resources

    I have a program that loops through a temp table, and for each row looks up a value in another table, and depending on the result returned inserts a record into one of two tables. Some days this takes 10 minutes to run and others it takes 2 hours to run. There are no other processes running against...

    Bleeb45 pointsBadges:
  • Oracle OMS – Please Help

    i'm expert on SQL Server, but new to Oracle world. the oracle is installed on Windows 2000, if i need to do anything (backup, creation of new Shema, importing data...)it gives me that i have to use OMS . i found that OMS needs sysman user, or after searching i found that this username doesn't...

    Sous580 pointsBadges:
  • sql Help

    I have a ten character field and need to exclude records if the first 2 character equal a specific pattern how do you do that?

    Sjstevenson5 pointsBadges:
  • Querying database tables with their descriptions

    I want to query an SQL server database for specific tables and their descriptions. How do I do that? Is there a special tool needed to do this?

    Sheni5 pointsBadges:
  • empty fields in a query

    I have a column with answers that people responded to different questions about themseleves. I have another column with the question id that the answer corresponds to. i want to display the answers in separate columns based on which question it corresponds to. Each column should be filled with the...

    Bananahead60 pointsBadges:
  • SQL Server 2005 and Powerbuilder 6.0

    We currently use Powerbuilder 6.0 with SQL Server 2000. We want to upgrade to SQL Server 2005. Does anyone know if SQL Server 2005 is compatible with Powerbuilder 6.0?

    Jfel5 pointsBadges:
  • What are the steps involved in copying the website from production to preproduction server

    what are the steps involved in copying the website from production to preproduction server

    Sangeeth30 pointsBadges:
  • DATEDIFF – 1 year off

    I need to figure out age from a birthday. When I use the DATEDIFF function for year, the number of years is one year ahead if the birthday hasn't passed yet for this year. How can I get the accurate age based on the day and month of the birthday.

    Bananahead60 pointsBadges:
  • split column

    i need to take a column in my database and split it into different columns based on a question id. Basically i want to write a whole bunch of sql statements that are non related for one grid - a whole bunch of sql statements each with their own where statement

    Bananahead60 pointsBadges:
  • SAP SQL database cluster

    Hi Our sap configuration include two nodes on win 2003 cluster/ The cluster using us for SQL 2005 . I need to upgrade the hardware. It is possible to add two new nodes to the cluster ? It is downtime necessary if i want to replace one of the nodes ? it possible to install the sap software when the...

    Sabi1330 pointsBadges:
  • SQL order by Issue

    Please help me write this. I need a SQL where the order by is done based on a variable passed to the query.SELECT * FROM (SELECT distinct gl.group_id, gl.group_name, gl.group_description, gl.status_code, gl.member_count, (SELECT grpp.group_name FROM test_group_relationship grel JOIN test_group grpp...

    Rohit331225 pointsBadges:
  • Different Results on Insert Select than Select

    I'm struggling, along with others, where I'm getting different results when doing an Insert select verses just the select. Lots of joins to get data from various tables. Only want the first record from the uniqfield table so created the tmp_uniqfieldid table with that item fielded, creation_ts...

    Bem35 pointsBadges:
  • Create report using Reportingservice, from a selected record from Datagrid

    Is it posible to bind the data from a record to a report, by clicking on that record in a Datagridview. Please some example code. Thanks, Matthew

    Spin5 pointsBadges:
  • How do I limit my SQL output to one record per student?

    Current resuls: Student ID: Guardian 2 Joe 2 Mary 3 Goldie 4 JIm Needed results: Student ID: Guardian 2 Joe 3 Goldie 4 Jim

    Richieg5 pointsBadges:
  • Substract two fields SmallDateTime at SQL Server

    Hii.. IT Professional Helper, may i asked 1 question and hope IT Professional Helper can help me to answer my question? The Question is : Cm.CommandText = "Update Reminder Set IsDatang = 0, IsValid = 1 Where TglReminder - TglDatangKembali > 7" Cm.Execute If i get the error : Arithmetic overflow...

    Suryanto5 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