Analysis Services (SSAS)

Security

• by bryan99y

• Database Journal

• Topic

Where can I find a good document on Securing a Database Server ? (ports, users permissions, etc)

2002-02-20

1 reads

SQL Mail Icon

• by runelords

• Database Journal

• Topic

I have a Clustered SQl Server 7.0 environment and I have noticed that the SQL Mail Service icon in Enterprise Manager shows that it is stopped but when I right-click and start it it indicates that it started sucessfully but the icon still shows that it is stop. I can also use xp_sendmail and it […]

2002-02-20

Alerts

• by runelords

• Database Journal

• Topic

I need to develop a alert that kicks off when the database size approached like 80% of it allocation. I know there is a predefined alert for percent log full but I need to develop this for percent database full. Any help would be greatly appreciates. Arthur Lorenzini

2002-02-20

Invallid character value for cast specification

• by PEnnenga

• JumpStartTV

• Topic

Can someone explain what the massage above means and how i can avoid this. I am trying to copy an AS400 table into sqlserver with DTS. The package creates an new table for the AS400 tabel in SQL server. But the proces is stopped and the message above is being stated. Can someone please lent […]

2002-02-20

DMO: sp.script -> Why do I get sp's PRIOR name?

• by Enwood

• Database Journal

• Topic

As a newcomer to SQL Server, I am confused about why DMO's "script" method of stored procedure objects is returning me the prior name of a stored procedure rather than it's current name. I had a stored procedure named "abc". I renamed the procedure by doing the following: (1) From VB6, opening a data link […]

2002-02-16

3 reads

Here is an ordering question for ya....

• by neilheuer

• SQLServerCentral.com

• Topic

I have a large number of records that have IP addresses. THey are like 123.45.0.1 to 123.45.0.253 I need to order these but using the traditional order the 200 are next to the 2's. so it would looke like .2 .20 .200 .201 .202 .203 ... to 210. Is there a way to order them […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-02-16

SQL Server RAM Usage

• by Barkingdog

• Database Journal

• Topic

Setting: SQL 7 Server (the only app running on the machine), PIII 733Mhz, 654 MB total RAM PerfMon readings: Processor queue length = 2.4 (average) Available RAM = 22MB (for many weeks) Drive C Paging file usage = 97% Drive D paging file usage = 6% Memory: Pages/sec = 0 Page faults/sec = 121 SqlCache […]

2002-02-08

3 reads

Support WebCast: How to Connect to Analysis Services over the Internet

• by Additional Articles

• Microsoft SQL Home

• Analysis Services (SSAS)

• Article

See how to configure and troubleshoot an HTTP connection to Analysis Services over both the Internet and an intranet. We will show you how to configure Microsoft Internet Information Services (IIS), and discuss the different security options for IIS in regard to Analysis Services. We will also talk about the client connection string and performance issues that may arise while using the HTTP connection.

2002-02-08

1,215 reads

• Discuss

SQL Mail Resources

• by Steve Jones

• Database Journal

• Topic

Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/sqlmailresources.asp

2002-02-07

2 reads

Data Dictionary from within SQL Server 2000

• by Mindy Curnutt

• Database Journal

• Topic

Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/mcurnutt/datadictionaryfromwithinsqlserver2000.asp

2002-02-07

42 reads