• Stored Procedures in SQL Server 2005

    Will you please explain me about Stored Procedures in Sql server 2005

    Rajanarina110 pointsBadges:
  • Adding another level of security to SQL 2005 database

    We have a SQL 2005 Database. It is protected by Windows Authentication. Can we add another level of security - requiring a SQL username and password along with a valid user name and password on the domain?

    NewnanIT1,110 pointsBadges:
  • SQL Server Disk Alignment

    What size should I set the Starting Partition Offset on the disks when running sql server 2005 32-bit enterprise edition, shuld it be 1024KB or 64KB?

    Rick Martinez585 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    project plan with steps outlined

    Anflores5 pointsBadges:
  • SRS 2005 Export to EXCEL

    Is there anyway to turn off Wrap Text formating on report rows/colimns as it is exported to EXCEL from Reporting Services 2005

    Oldmickey65 pointsBadges:
  • Best tool for SQL Server 2000 – like golden is for oracle

    what db tools are there to query ms sqlserver 2000 database? i'm used to using benthic's golden for oracle databases - and would like a similar tool to use with sqlserver databases.

    Angeliamcdaniel5 pointsBadges:
  • Recovering database files from failed Brightstor 12 server

    We have a failed brightstor 12 server. I can recover the files from the hard drive but the server is dead. We will be rebuilding a new one. Can I recover the database files and import them? And if so where are they located?

    Troubleshooter24755 pointsBadges:
  • Alter proc to fetch a table structure from SQL Server 2005 database

    hi please segest me... what is the problem in this proc. CREATE Procedure sp_tab @tablename nvarchar(517), @flags int = 0, @orderby nvarchar(10) = null, @flags2 int = 0 As if @flags is null select @flags = 0 if (@tablename = N'?') begin print N'' print N'Usage: sp_table_struct @tablename, @flags...

    Amitshukla60 pointsBadges:
  • Migration checker tool for Sql Server 2000 to Sql Server 2008 Migration

      Hello, Please let me know is there any tool available to check the SQL Server 2000 to Sql Server 2008 Migration, so that we can anlyze the procedure or any discrepancies with the Database we are trying to migrate and list all potential issues. Thanks Naina

    Naina5 pointsBadges:
  • Migrating SQL Server 2000 to SQL Server 2005

    How can we migrate our sql server 2000 to sql server 2005 on another box? We have about 36 databases and it is around 65 terabytes of data on an external array. The array will be connected to the new server.

    TeachMeIT975 pointsBadges:
  • Linked Server Query Returns Incomplete Results

    I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I'm querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the query I'm using: select * from...

    Apickel350 pointsBadges:
  • i want to develop a s/w in java and back end as sql server

    i want to develop a s/w in java and back end as sql server , what are the form creation menu bar program

    Paulgeo845 pointsBadges:
  • I need to replace a word in a Document through SQL Server 2008

    Hello  i'm using SQL 08 R2 to store my resume collection , i want Sql to find an Email  in the MS WORD document and replace it with an empty string  so far I've succeeded to find the word using fullTextSearch  this my example for finding the documents that contain an email  SELECT  document...

    Shayguri15 pointsBadges:
  • Email Notification If Scheduled Task In Windows Fails

    Hi All, I have scheduled an archiving process using the Scheduled Tasks in windows (2000 server). The task is running fine as per the schedule. But everyday I have to manually check whether it went fine or not. Is there any way by which I can send an email notification if the scheduled task fails...

    Bakash0 pointsBadges:
  • Execute trigger only on update of selected fields

    We have created some trigger programs in COBOL that should be executed only if certain fields change. When creating a SQL-After trigger and -program on a file I can specify that the trigger should run only when specified fields are updated by using: AFTER UPDATE OF {fields} ON {file}. Unfotunately...

    r.otto810 pointsBadges:
  • Backup solutions for VMware environment

    We've added VMware servers to our data center, and we're looking for a backup solution that works. There will be a mix of ESX 4.0 and ESX 3.5 hosts along with vCenter 4.0 with a mix of Windows Server 2003, Windows Server 2008, Red Hat 4.x and 5.x, SQL Server 2005 and Oracle database. TSM is...

    ITKE346,360 pointsBadges:
  • Migrating stored procedures from SQL Server 2000 to 2005

    after migrating store procedures from 2000 to 2005 sql server, how we can check the store procedures are migrated correctly without executing them?

    Parveshkaur5 pointsBadges:
  • Recursive Association with compound primary key in SQL database

    Hello, I'm afraid I'm very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a 'Lead Client' column to represent a recursive relationship where one attendee can be nominated to lead...

    Littlegreen15 pointsBadges:
  • T-SQL Programming Tutorials

    I am looking for a website that is free and where I can learn to write better T-SQL views and stored procedures.  Also, would like to find some good books to learn more about managing a SQL 2005 database.

    Luby10 pointsBadges:
  • SQL Server 2005 query

    Hello sir I am new to sqlserver when retriving data like name gender sal deptno df F 100.00 10 mf M 1100.00 10 if M 1010.00 10 uf M 1000.00 20 yf F 1200.00 20 gf F 1030.00 20 hf M 1005.00 30 ff F 1040.00 30 from this i want retrive deptno maletotal sal female total sa 10 2110 100 20 1000 2230 30...

    Udaya5 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