Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help with query/scripts

Author  Topic 

mult
Starting Member

2 Posts

Posted - 2012-12-05 : 06:16:51
Could anyone please help with a script that could get relevant information about monitoring activity on SQL server to popular social web sites such as Facebook, Yahoo, Twitter, Google+ etc. To begin with, we need a query creating that shows large files (>10MB) that are entering or leaving the network to and from these sites. Can anyone please advise it would be much appreciated.
As I am an IT apprentice and I'm a bit lost on this topic.
Thanks.

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-12-05 : 06:48:12
Do you already have some data in sql server that you want to query or are you looking for something that will monitor network traffic (which wouldn't be anything to do with sql server).

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

mult
Starting Member

2 Posts

Posted - 2012-12-05 : 07:51:41
I already have data which is captured by finjan swg.

Thanks for the reply
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-12-05 : 08:13:19
Post the schema for your tables along with some sample data and the required output corresponding to that sample data. This blog might help to formulate the question:

http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page
   

- Advertisement -