it all comes down to connectivity.

for example, if a server is exposed to the internet, you can connect by IPAddress-comma-port instead of machine name: ie 209.191.122.70,1433 and then use a...

on any one physical server, you may install as many instances as you want under that license.

the license is really per machine, not per instance.

http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20Overview%20final.docx

i had not seen anyone try that before...getting a file from an url.

I'm awful sure the retrieving of an attachment is a file operation only, and the file must exist...

i don't think you can have variable names with the dash in them...it's interpreted as trying to minus something from the value @sd

change your variable to @sd adn @sdaux and...

for whatever reason, reading email and/or attachments was possible in SQL 2000, but deprecated for 2005 and above, i believe.

the code to read a POP3 mailbox in .NET is pretty...

sushantkumar1984 (7/22/2010)

---

@ lowell

So the synonyms A,B and C which i created will be local to database level or server level..?

and how to deallocate those synonyms once the use is over?

thanks

Sushant

Virgin...

sushantkumar1984 (7/21/2010)

---

is there a method to avoid writing the server name in a query..

like xyz.dbname.dbo.tablename1 A

xyz.dbname.dbo.tablename2 B

...

i think you'll want to use a monitoring software package that tests the server and the services that exist on it; you can't relaly expect the server to monitor itself...

well I know about the listening port for SQL Server...the other services, I'll await other more knowledgable users to chime in.

the default instance uses port 1433 until you change it.

additional...

well, i'm confident you didn't misspell the user, so here is my best guess:

the user Fateme_Hei is probably already a sysadmin. that LOGIN does not also have to be a...

that error is usually because the url to the mail server is incorrect, or there's no...

here's the default trace scripted out so you can see and add more events, etc and create a replacement that might last longer than the default:

default_trace_script.txt

also this part:

'The service queue "LoggingQueue" is currently disabled.'

you have to kick everyone off of the database to run the script to set up the queue; exclusive access is required....

I'd think sa has access to everything if it exists...

if you don't filter by application name, your hours using the ERP will be inflated for developers who connect with SSMS...

rule of thumb for me is if the @TableVariable has anywhere near 1000 rows or more, it should be changed to a #temp table instead...

after that, it would take some...