I don't want to disappoint you, but when a government changes, the government itself is most likely the only thing that...

I don't think it's possible.

SSMS stands for SQL Server Management Studio, the client tool used for queries and management.

20% is a standard threshold because NTFS starts degrading performance under 15% of free space.

I would recommend that percentage: it lets you discover problems before they arise.

You'll probably get the best help posting in the appropriate forum:

http://www.sqlservercentral.com/Forums/Forum5-1.aspx

You can run multi-server queries with SSMS.

It's not the same as monitoring with the Job Monitor, but you can get the information in a result set.

Can you set up the linked server directly, usgin the teradata oledb provider?

Some ideas here:

http://weblogs.sqlteam.com/phils/archive/2005/11/30/8466.aspx

Steve Jones - Editor (6/16/2010)

---

I...

As far as I know it's not possible to force the use of comma as decimal separator in T-SQL code.

You can use it in SSMS to display data.

Duplicate post, no replies please.

Redirect here: http://www.sqlservercentral.com/Forums/FindPost938196.aspx

This makes things a little bit more complicated, but not impossible:

SELECT *

FROM msdb.dbo.sysjobschedules SJ

JOIN msdb.dbo.sysjobs S ON S.job_id...

You could use Sybase. That works on UNIX.

You don't need to put the job_id equality condition inside the correlated subquery, since there's the ON clause to do that:

select *

from msdb.dbo.sysjobschedules SJ

...

You're not giving out much information...

Can't you avoid using DSNs?

You're not expecting somebody to look at all this code, are you?

Try to reduce the surface, or nobody will reasonably help you.

Take a look at the article linked in my...

ColdCoffee (6/16/2010)

---

Gian, we can write this also like this , right?

select @user-id = USerID

where

firstname = SUBSTRING(@@UserName, 1, CHARINDEX(' ', @@UserName) - 1)

and lastname...