SQL Alert

Hello, I'm having problems accessing a mapped network drive. Basically, I need to be able to access the g:\ drive from SQL Server (i.e...

Hi All, I have used .Children function to retrieve members of dimension at one level below the current level of dimension. For example (usin...

I've been able to get the local temporary table name from sysobjects, but I still can't select from it. for example, the following s...

We have a view in one database that consists of the union of all the rows in a set of tables located on a number of remote linked servers. ...

Is there any way to access a linked server without using four-part naming? My problem is that I am trying to find a way to connect to an acc...

I created a linked Excel server that is stored in a SQL2000 database. I can run the following from the SQL server with no problem. Select * ...

Hello! I would like to allow non-admin users seeing all jobs (including ones they do now own) in Enterpise Manager.SQL Profiler displays exe...