SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help with query/scripts
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mult
Starting Member

United Kingdom
2 Posts

Posted - 12/05/2012 :  06:16:51  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
3383 Posts

Posted - 12/05/2012 :  06:48:12  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
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

United Kingdom
2 Posts

Posted - 12/05/2012 :  07:51:41  Show Profile  Reply with Quote
I already have data which is captured by finjan swg.

Thanks for the reply

Edited by - mult on 12/05/2012 08:04:38
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 12/05/2012 :  08:13:19  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000