more details from you before anyone can help; it's all specific to YOUR network.

what is the address of yout SSRS server? are you connecting to a .com address or a...

you can also establish a regualr ADODB connection and connect to the server, without having any SQL client tools installed. there are a lot sample apss that can do that...

you'll need to handle errors a s a separate email, something like this:

DECLARE @Results int

EXEC @Results = msdb.dbo.sp_send_dbmail

@profile_name = 'AdventureWorks Administrator',

@recipients = 'danw@Adventure-Works.com',

@body='Whatever the...

this was about the only thing that made sense to me;

SELECT

ID,

[month],

[year],

CASE

WHEN month(getdate()) IN...

this is actually a question for Network Solutions...if they expose their SQL Server to allow you to connect directly, then yes.

If it is hidden behind a firewall, then no.

I have...

the secret is to join the table against a copy of itself.

this example is most of the way there...the only problem is that it returns more than one row.

that can...

mcginn (5/14/2009)

---

I have a table where each row has a unique timestamp column. In many cases other then the timestamp column, all of the other values are dups of another...

it's still just a hyperlink...your computer resolves the path for you.

Some Excelfile on a web server with DNS

Some Excelfile on personal web server by name

Some Excelfile...

it's best to use the GUI in designer. you cannot actually insert between column...behind the scenes you have to create a new table with the newly designed "correct" structure complete...

Create table #TempA ( Name Varchar(20), Age Int,Hobby Varchar(20),HobbyCode Int)

maybe I'm reading the requirements wrong, but if you want the current distinct combinations that exist in the table, would it...

I thought it's probably 30 million records, and not 30 million users, which I thought was on par witha Google sized-installation....but

just for fun, i searched for Google Searches per day...found...

you'll need to make it a UNC path, like \\ServerName\SharedFolder\Filename.txt or whatever.

you cannot put it on a C:\ drive, it has to be a share since you want other people...

i have this saved, because it is a great resource for determing the minimal impact that a trace incurs:

http://sqlblog.com/blogs/linchi_shea/archive/2007/01/16/performance-impact-of-enabling-page-checksum-and-default-trace.aspx

i created a view to see the data in my DML trace..only thing obvious i saw was to simply do a SELECT * from myDMLView where TextData like '%#%'...

there is no limit to the number of views you can create, even if they reference the same object over and over.

you can create views against system tables, but they...