• 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:
  • 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:
  • 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:
  • 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:
  • 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...

    ITKE350,945 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:
  • 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:
  • SQL Server 2005 with SAN storage problem

    i have a very strange problem: - i have an  windows 2003 server - a SAN storage attached to that server - i installed SQL server 2005 proffesional into the server - database files in the san storage - when i attach the database into the san storage it gives an error that it cann't see the drive E...

    Masterofpcs5 pointsBadges:
  • SQL I/O Best Practice

    I just inherited a SQL SERVER 2005 32-bit attached to a SAN Server. I want to use SQLIO for performance testing and stress testing. The database is in production. Would it be a good idea to run SQLIO on a production sql server during non-work hours?

    Rick Martinez585 pointsBadges:
  • Value of() in SQL Server?

    what is the equivalent statement of valueof() of oracle in sql server?

    Prcvjr220 pointsBadges:
  • How to create data security in SQL server 2005 so that the code will not be opened

    how to create data security in sql server 2005 so that the code will not be opened

    Gkhlhlhjhhghgg15 pointsBadges:
  • Question on SQL 2005 table

    tablename:-software pname             packagename                    cost MARY               README                             1200 ANAND             PARACHUTES                     6000...

    Vijaykumar45625 pointsBadges:
  • SQL Server 2005 procedure to Create stored procedure

    sir,plz tell me the procedure from strating that how to create stored procedure

    Gkhlhlhjhhghgg15 pointsBadges:
  • Crystal Reports 8.5 compatibility with SQL 2005

    Is crystal 8.5 compatible with SQL Server 2005?

    CrystalPrincess5 pointsBadges:
  • Add an Active node to SQL Server Active Passive Cluster

    how will i add an active node to an existing Active/passive SQL Server 2005 Cluster. so that when any active node fails the passive will be used.will there be a down time for the current cluster Jasina

    Jasina30 pointsBadges:
  • Can’t bring master database back online

    hi,i bring master database into offline. after that i tryed so many times to make master database as online.But i did't get that one into online(production side)wht is root cause for that?

    241219840 pointsBadges:
  • How to transfer database from SQL Server 2008 to SQL Server 2005

    how to attach database of  sql 2008 into sql 2005

    Itready5 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