I have sql server developer 2000 on my XP machine, iam on a public IP and this makes my system vunreable to attacks, today my ISP reported that the sql server...
Hi Praveen, right now What i can think of here, are the following options - 1) Very first, if u r on public network - change ur SQL default Port 1433 to other...
173
imformhyd
praveenonline@...
May 4, 2004 1:35 pm
... being ... i ... box.. ... baghzaad that worked for sql .. waiting for the IIS ..solution....
Hi, ... right now What i can think of here, are the following options - 1) Very first, if u r on public network - change ur SQL default Port 1433 to other...
175
imformhyd
praveenonline@...
May 5, 2004 6:16 am
thanks .. satya,, will follow ... Port 1433 to other port. ... IP to Private IP where end-user will not come to know abt ur public Ip and passed private ip is...
For yr frontpage problem u have to create accounts first on the machine where it is installed. These accounts are not windows account but accounts that u have...
177
imformhyd
praveenonline@...
May 5, 2004 2:44 pm
iam trying to create a oledb provider link using UDL fild on XP machine i have developer version of sql server2000, when i try to use the UDL wizard for .udl...
Hi Go to the SQL Server properties and change the logon as Mixed mode. imformhyd <praveenonline@...> wrote: iam trying to create a oledb provider link...
I know why yr Enterprise Manager hangs up. Its because your firewall is blocking it. You cannot deny access to Enterprise Manager and then try to use it to...
180
imformhyd
praveenonline@...
May 6, 2004 10:16 am
This helped me "Trusted_Connection=true", will be helpful... :) cnn = New SqlConnection("Server=localhost;Database=test;User ID=sa;Trusted_Connection=true") ...
Hi satya, I am suresh working as SQL DBA in HP Bangalore. There are 3 vacancies for Sr.Sql DBA in our Company. In case you are intested pls forward your cv...
182
Sanjay Gupta
praygodalways@...
May 8, 2004 5:08 am
Pls send resumes if you are interested in change. _________________________________________________________________ Post Classifieds on MSN classifieds....
183
imformhyd
praveenonline@...
May 10, 2004 11:58 am
Iam sorry if iam breaking any convention by placing a requirement that is not concerned with the techonlogy of this group, but i strongly feel a job is a job...
184
patrimadhu
patrimadhu@...
May 11, 2004 12:00 pm
There are openings in J2ee,SAP BIW,System Admin.with Solaris with 2-3 years experience....
SET NOCOUNT ON Cultivate the habit of using SET NOCOUNT ON inside a stored procedure whenver possible. By default when a stored proc is executed, the server...
188
sanjay gupta
sguptasolntec@...
May 13, 2004 1:11 pm
We require SQL DBA's for Hyderabad for our projects. Please send your resumes if you are interested in changing your job. Email : sguptasolntec@... ...
Hello, I am a newbie to .NET and SQL Server... I am trying a simple database access using ADO.NET/SQL server in the following VB.NET program: Imports...
Hi, The problem is with the connection string. You have not passed the correct credentials. Please check that. And please use try catch statements so that u...
Hi Friends, I got this mail from one of my fellow MVPs, please try to provide some information on this Thanks Sudhakar Hide options 9:46am (2 hours ago) From:...
192
Ram Kishore CH (Wipro...
v-ramkch@...
May 19, 2004 6:36 am
Tip of the day GET COUNT(*) FROM 1 TABLE IN a scenario where the user would like to retrieve the Count(*) from a table without any condition, in that case this...
193
Anand Vijayaragavan
anandv123@...
May 19, 2004 6:38 am
Hi All, I have written an batch file that is use to take a backup of the existing procedure from the database and stores in a undo\sprocs\ directory. Code: FOR...
Hi All, I have written an batch file that is use to take a backup of the existing procedure from the database and stores in a undo\sprocs\ directory. Code: FOR...
Sudhakar, there is same kind of debate going on sswug.org site. You may want to check that out. (I think u need a subscription for that) You can also find SS...
One thing to keep in mind. "sysindexes" table does not get reflected online. If the table has high density of inserts(or for that matter deletes), then it is...
You can start any remote SQL server from ISQL (query analyzer) itself if you have privileges to start that. In "Connect to SQL Server" dialog you can see the...
Kumar, It would have been better if you had explained "Remote" more precisely. If you are connecting with any of the remote connecting tools such as TS or PC...
That's interesting.. I have something which are basically inferences based upon the mail thread. Please don't shoot me for I am mostly in the dark wrt sql <g> ...
Group, I was planning to enable AWE on one of our production boxes for SQL Server. But I could not locate boot.ini on system root and infact I tried all kinds...
I know the below explanation doesn't fulfill Teucer's questions but still wanted to share with you all - - In my no work & all TP days, i did some research to...
