• DBCC CHECKDB

    before runing DBCC CHECKDB WITH repair_allow_data_loss, How can i know what table and data that will be deleted

    Sreenu125 pointsBadges:
  • SQL 2005 SSIS Package to load table from positional flat file

    I have a positional flat file which I need to load contents into a SQL table. I've created an SSIS package and will need to call a VB script to parse the file but since I'm new at VB and SQL I need some assistance creating the VB script. There are 4 fields in the table I need to populate. The first...

    Dacker5 pointsBadges:
  • Retrieving Records based on Record Selection from another table

    I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables,...

    Tjlevin10 pointsBadges:
  • Changing BCP format file collation

    Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. Thanks.

    Db23290 pointsBadges:
  • DTS import/export

    Hi, I was wondering if the DTS import/export also recreate the table, the reason I am asking this I want to recreate a database using the Generate SQL Script but change the collation of the columns of the table, then import the data from that database to this new database. If it does recreate the...

    Db23290 pointsBadges:
  • Removing data in a column after a hyphen

    We imported a text file and one of the columns has first and last names in it. However, there is sometimes a hyphen with a title after the name. We need to create a SQL statement that will look for the hyphen and remove it and anything following it. Example: Column 1 Column 2 02/18/09 John Doe...

    Sunitalynn15 pointsBadges:
  • Changing Database Collation

    Hi, I am trying to change the collation of a database and the table and columns, does anyone now how to do this? Thanks.

    Db23290 pointsBadges:
  • Changing SQL Server name and SQL Server group name

    Hi, I have notice that our dev and prod SQL Server has SQL Server name and SQL Server group name that is different to the machine name. We are planning to change it to match the machine name. To do this, from what we have read, you change the SQL Server name using the sp stored procedures to drop...

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

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.

Thanks! We'll email you when relevant content is added and updated.

Following