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...
imformhyd
praveenonline@...
May 3, 2004 1:27 pm
172
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...
... being ... i ... box.. ... baghzaad that worked for sql .. waiting for the IIS ..solution....
imformhyd
praveenonline@...
May 4, 2004 1:35 pm
174
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...
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...
imformhyd
praveenonline@...
May 5, 2004 6:16 am
176
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...
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...
imformhyd
praveenonline@...
May 5, 2004 2:44 pm
178
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...
This helped me "Trusted_Connection=true", will be helpful... :) cnn = New SqlConnection("Server=localhost;Database=test;User ID=sa;Trusted_Connection=true") ...
imformhyd
praveenonline@...
May 6, 2004 10:16 am
181
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...
Pls send resumes if you are interested in change. _________________________________________________________________ Post Classifieds on MSN classifieds....
Sanjay Gupta
praygodalways@...
May 8, 2004 5:08 am
183
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...
imformhyd
praveenonline@...
May 10, 2004 11:58 am
184
There are openings in J2ee,SAP BIW,System Admin.with Solaris with 2-3 years experience....
patrimadhu
patrimadhu@...
May 11, 2004 12:00 pm
185
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...
We require SQL DBA's for Hyderabad for our projects. Please send your resumes if you are interested in changing your job. Email : sguptasolntec@... ...
sanjay gupta
sguptasolntec@...
May 13, 2004 1:11 pm
189
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:...
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...
Ram Kishore CH (Wipro...
v-ramkch@...
May 19, 2004 6:36 am
193
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...
Anand Vijayaragavan
anandv123@...
May 19, 2004 6:38 am
194
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...