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

Answer Question   |  January 13, 2011  4:53 AM
SQL Server, SQL Server 2005, SQL Server stored procedures, SQL stored procedures, Stored Procedures

How do you set a SQL Server job step status?
I am running SQL Server 2005. I have a job that has six steps to load a database table from an external source. The external source is required to send the file nightly. In system testing I found this is not always the case. I created a batch ‘step’ (Step 3) to check if the [...]

Answer Question   |  January 17, 2011  11:28 PM
SQL Jobs, SQL Server 2005, SQL Server 2005 SP3, SQL Server database

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?

Answer Question   |  January 12, 2011  5:55 PM
SQL 2005, SQL Server, SQL Server 2005, Windows Server 2003, Windows Server 2003 32-bit

SQL SERVER 2005 Storage Performance
We have an IBM server xSeries 460 with a QLogic FC HBA card 4gb on the server with a PCI-X 266MHz bus speed (16 CPU 667MHz FSB, 32GB RAM). The HBA card connects to a Brocade 5000 switch then to the SAN Controller then to a Cisco 9124 Switch then to SAN Drives all through FC. [...]

Answer Question   |  January 18, 2011  6:30 PM
SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance, Windows Server 2003, Xiotech

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

Answer Question   |  January 11, 2011  1:20 PM
SQL Export to Excel, SQL Server 2005, SQL Server Reporting Services, SSRS 2005

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 int = 0′ print N’ where [...]

Answer Question   |  January 7, 2011  9:59 AM
FETCH statement, SQL 2005, SQL 2005 Database, SQL Server 2005, SQL Server tables

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 [...]

Answer Question   |  January 3, 2011  7:57 PM
Desktop virtualization, ESX 3.5, ESX 4.0, Oracle Database, RedHat, Server virtualization, SQL Server 2005, vCenter 4.0, VMware, Windows Server 2003, Windows Server 2008

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?

Answer Question   |  January 3, 2011  4:06 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server stored procedures

How to Display Japanese character in Crystal Report 8.5
Hi, I’ve some data stored in japanese language in sql server 2005 database using nvarchar datatype. When i execute store proc in sql server, it’s showing japanese character properly in sql server. However, when i’m trying to display data in crystal report 8.5, it’s showing ????? character. I’ve tried to change font to ‘Arial Unicode [...]

Answer Question   |  May 6, 2012  11:14 AM
Crystal Report 8.5, NVARCHAR, SQL Database, SQL Server 2005, SQL Server 2005 Database

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 [...]

Answer Question   |  December 31, 2010  7:54 AM
SQL Query, SQL Server 2005, SQL Server Query, SQL statements

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?

Answer Question   |  January 12, 2011  4:17 PM
Network security, Network Security Management, SQL 2005 Database, SQL Security, SQL Server 2005, SQL Server security, Windows authentication

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 [...]

Answer Question   |  December 20, 2010  10:20 AM
SAN, SAN storage, SQL 2005, SQL Server 2005

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?

Answer Question   |  December 20, 2010  10:11 PM
iSCSI SAN Server, SQL 2005, SQL Server 2005, SQL Server administration, Windows Server 2003

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

Answer Question   |  December 16, 2010  12:22 PM
Oracle Statements, SQL, SQL Server, SQL Server 2005

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

Answer Question   |  December 13, 2010  9:52 AM
SQL Security, SQL Server 2005, SQL Server 2005 security, SQL Server security

Question on SQL 2005 table
tablename:-software pname             packagename                    cost MARY               README                             1200 ANAND             PARACHUTES                     6000 ANAND             VIDEO TITLING                   16000 JULIANA           INVENTORY                        3500 KAMALA           PAYROLL PKG                    20000 MARY                FINANCIAL ACCT             85000 MARY               CODE GENERATOR          20000 PATTRICK        README                            1200 QADIR               BOMBS AWAY                 3000 QADIR               VACCINES                      3100 RAMESH             HOTEL MGMT                35000 RAMESH               DEAD LEE                    4500 REMITHA              PC UTILITIES                5000 REMITHA               TSR HELP PKG             6000 REVATHI             [...]

Answer Question   |  December 11, 2010  8:39 PM
SQL 2005, SQL Server 2005, SQL Server tables, SQL tables

SQL Server 2005 procedure to Create stored procedure
sir,plz tell me the procedure from strating that how to create stored procedure

Answer Question   |  December 11, 2010  11:19 AM
SQL 2005, SQL Server 2005, SQL Server stored procedures, SQL stored procedures

Crystal Reports 8.5 compatibility with SQL 2005
Is crystal 8.5 compatible with SQL Server 2005?

Answer Question   |  December 10, 2010  4:45 PM
Crystal Reports 8.5, SQL, SQL Server, SQL Server 2005

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.

Answer Question   |  December 31, 2010  5:18 PM
SQL 2005 Database, SQL Server 2005, T-SQL

Install SQL Server 2005 without Local Admin
Books Online tells me … make sure you have administrator permissions on the computer where SQL Server will be installed. Based on the principle of using the lowest possible user rights is it possible to safely install SQL Server 2005 using an account or group that has the required level of privileges but no more. [...]

Answer Question   |  December 2, 2010  5:07 PM
Local Administrators Account, SQL Server 2005, SQL Server administration, SQL Server installation, Windows Server 2003