• Remote connection on SQL Server 2005 Express

    shibu.govind is online. shahina: http://support.microsoft.com/kb/914277 Sent at 11:26 PM on Tuesday shahina: F:\C#PROJECTS\QMSED2.0\QMSED\BIN\DEBUG\QMSED\QMSED.MDF Sent at 11:52 PM on Tuesday shahina: firewall.cpl Sent at 12:20 AM on Wednesday shahina: C:\Program Files\VMS\Rlink SMS Ed V2.0 3:35 AM...

    999559534735 pointsBadges:
  • Display Query for OS/400 SQL script

    Is it possible to view the SQL that is generated by a query created in Query for OS/400. I have the query defined as I want it and would now like to give the SQL script to my development team to use in automating reports by accessing the database directly.

    Tomotsk75 pointsBadges:
  • Crystal Reports in Web application with SQL Server 2005 Express

    i want to create crystal report in asp.net 2.0 web application with sql server 2005 express edition. now the name of my database which i have created its name is Database.mdf. now whenever i expert database i can find my server name but in the dropdownlist of database i can`t find my database name....

    Softdeveloper10 pointsBadges:
  • SQL Log files

    Can I delete a SQL log file

    RSCC5 pointsBadges:
  • Fulltext Search – SQL Server 2005 SP2

    I am new to the SQL Server 2005 Fulltext search technology and I have not tried it yet myself. I would like to ask about availability of a feature which is provided for example by the Oracle Text technology which is indexing documents using FTP protocol. I have various formats of text documents...

    Repo5 pointsBadges:
  • Execute command in SQL

    can someone tell me the error in this statement declare @cmd nvarchar(4000) declare @PatNo bigint set @PatNo=123 set @cmd= N'insert into TmpDues ( PatNo, BillDate, ReceiptNo, PayMode Amt) select ReceiptTable.PatNo,ReceiptTable.BillDate,ReceiptTable.ReceiptNO,'+ '''Cash'''+' as PayMode,CashAmount...

    Ash1235 pointsBadges:
  • SQL Server Agent Job Creation

    Hello, My self Ashish Amodia from India, I want to send Automatic mail with an attachment for that I have created job and from job that I want to open my web page automatically - I am using SQL server 2000. If u know how to open web page from job than please let me know :) Thank you

    AshishAmodia20 pointsBadges:
  • Going from SQL Server 64-bit Enterprise to 32-bit Standard

    Can the database be moved from a 64-bit Enterprise Edition SQL server to the 32-bit Standard Edition? What kind of issues there might be associated with this move?

    Narine5 pointsBadges:
  • 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:
  • 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:

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.