no 1 here, iam the only who will have to fix it, cannot find any tutorials on the net, windows firewall should have proper simple thing

i allow that ip, but...

still 3 options

allow the connection

allow the connection if it is secure

block the connection

now if i choose allow for ip then will it allow to that ip?

iam using windows firewall with advance settings

it only provides three option

allow the connection

allow the connection if it is secure

block the connection

where is the option to allow only from specific ip

iam the admin, i did created 2 rules, one allowing specific ips and other blocking connections to 1433,34 any idea, its not working

its blocking all connections

using windows firewall advance settings

i tried firewall, but i didnt seem to find any option to allow only specific ips and block all others for port 1433,1434

i found the solution for it, and iam posting it so it wud be useful for others

go into sql server configuration manager

just run the sql full text filter data dameon...

any easy way to just check 1 column, some tables are huge with 80,90 columns, it wud be so bad to type each column name

any easy way to just check...

thanks i never knew that, iam writing triggers for the first time i guess

i have deleted for that table, i have wrote similar trigger for another

table

iam pasting code

USE [joblist]

GO

/******...

iam using sql server management studio

iam unable to see it the database/programmabilit/triggers section

my website had been subjected to sql injections

my website had been injected 4 times a day, my table...

iam unable to see the code via enterprise manager, any sql query to get the code ?

i got the trigger name by doing a query on sysobjects

actually its nothign great

create...

hello

no 1 said about creating login with limited access, instead of triggers?

is triggers better than a restricted login

it doesnt work that way it gives error when data is large, every...

what about not allowing nulls, cannot set via gui it has over 150,000 records

my table column doesnt have default now, it allows null value, i want to it to not allow nulls, but have 0 value instead

i tried that also but

it says

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'set'.