Search Results | SQL Server Performance Forums

create a sql server 2005 new login for SQL Injection prevention

Thread by: gopalanmani, Sep 1, 2010, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, Our database affected with SQL Injection. so We need to create a sql server 2005 new login for SQL Injection prevention User can perform,...

System.Data.SqlClient.SqlException: Login failed for user <UserName>. Reason: The account is disabled.

Post by: gopalanmani, Aug 25, 2010 in forum: SQL Server 2005 General Developer Questions

Thank you for your response. I am using the same login info for web access. but i didnt get any 'Login failed' errors from web application and also...

System.Data.SqlClient.SqlException: Login failed for user <UserName>. Reason: The account is disabled.

Thread by: gopalanmani, Aug 24, 2010, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, Thank you for advance. I created a widows service for mail schedule with c#.net and sql server 2005 and it is working fine for past one...

convert the table into excel sheet

Post by: gopalanmani, Dec 8, 2009 in forum: Getting Started

hi, check this code, OPENROWSET ( { 'provider_name' , { 'datasource' ; 'user_id' ; 'password' | 'provider_string' } , { [ catalog. ] [...

SQL server data backup from remote server

Thread by: gopalanmani, Dec 23, 2007, 1 replies, in forum: General Developer Questions

Hi, I want to SQL server data backup from remote server. I can able to access remote server through query analyzer only. how can i Possible do that...

Display of Data category wise

Post by: gopalanmani, Dec 13, 2007 in forum: T-SQL Performance Tuning for Developers

Thank you

Display of Data category wise

Thread by: gopalanmani, Dec 13, 2007, 2 replies, in forum: T-SQL Performance Tuning for Developers

I need to list all the categories in order like tree view model. my category table structure --------------------------------------- catid catname...

Moving SQL Server From One Server to Another

Thread by: gopalanmani, Apr 18, 2007, 2 replies, in forum: General DBA Questions

Hi, I need to move all my data [users, roles EVERYTHING] from one server (running production) to new another production server. so I can...

stoted procedure using text data type - issue

Thread by: gopalanmani, Dec 28, 2006, 2 replies, in forum: General Developer Questions

Hi all, i have used to text datatype in stored procedure. but i am getting this error: The text, ntext, and image data types are invalid for...