• 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:
  • Finding nth most recent action with SQL

    I am trying to determine the date on which a certain number of things have happened cumulatively, eg I have a varying number of buyers each month. I want to find out on what date of that month, those buyers make their 3rd purchase. My SQL doesn't seem to support TOP or ROWCOUNT so I would...

    Munona995 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:
  • question: T-SQL stored procedure conversion to C# CLR assembly….

    I'm wondering why it is difficult to find an example ( in literature or Internet ) example of converting a T-SQL procedure which contains "out" variables into identical C# CLR stored procedure. Is there something which prohibits this conversion ? If not, can someone provide or cite example ? Real...

    Tann5 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:
  • stored procs in Master db, sql server 2005

    Does anyone know where I can get a list describing, in layman's terms, all the sp_usr... stored prodedures in the Master database? New to all this and don't have the time or knowledge to decipher the TSQL behind it. Hope someone can help! Cheers

    GillsJules5 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:
  • How do you create stored procedures in SQL Server 2000?

    How do you create stored procedures in SQL Server 2000?

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

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