Analysis Services (SSAS)

RE: Explore Snapshot Folder error

• by sos

• SQLServerCentral

• Reply

I'll check as you suggested and see what that reveals, but I also created a new Publication and didn't change the directories, I just left the default Admin directory and still got the same problem!!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-14

RE: Dynamic SQL With USE

• by kknudson

• SQLServerCentral

• Reply

Thanks Greg, a slight variation of what you provided, solved it perfectly. KlK, MCSE

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-14

RE: Repeated SQL Alerts

• by paulhumphris

• Database Journal

• Reply

Thanks MarkusB for the prompt response. I have now written a script to run as a SQL Job when the Alert fires, this script drops and recreates the Alert with the threshold value incremented the value in sysperfinfo.

2003-05-14

RE: Explore Snapshot Folder error

• by Rodrigo Acosta

• SQLServerCentral

• Reply

Check running sp_browsesnapshotfolder to see if it finds it. If not I think that you didn't changed right the property of the snapshot folder. If possible, drop and re create the publication with the new alternate snapshot folder.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-14

RE: Computer lazy after error on programming with SQL

• by well0549

• SearchSQLServer

• Reply

Well Simple...... I would not look in SQL server for a start. But in the page. To see if the sluggishness of the system is really caused by IIS. Try IISRESET. Thie will stop and strat all IIS related stuff. If it is fast then you know you got a problem on your ASP page.....

2003-05-14

RE: Executing master stored procedure

• by dgermundson

• TechNet Blogs

• Reply

I've found a workaround. I ended up piping the results of sp_helpdb to a temp table then querying off of that to my daily space utilization table. Thanks for the responses. Darren

2003-05-13

RE: Distribution Statistics

• by Chris Kempster

• SQL Server Performance

• Reply

Hi there I believe they do, especially if the so called "parameter sniffing" feature of sqlserver is still around. Run something like this for example: DBCC SHOW_STATISTICS (mytable, PK_MyPrimaryKey) this returns info similar to what I would expect for disribution statistics with a date of the refresh. Cheers Chris K

2003-05-13

RE: Computer lazy after error on programming with SQL

• by dig

• SearchSQLServer

• Reply

Dear martins OK! Sure! Closing the recordset must be in the "pattern"-closing coding! It is in mine! Nevertheless, thanks for the advice! Dalton

2003-05-13

RE: Unused login accounts

• by James Travis

• Database Journal

• Reply

You can also audit your logins with either Profiler to capture connections or if you right click the Server in question in EM and choose properties you will find Audit level options on the Security tab (you will have to stop and restart the service to use this and to turn off).

2003-05-09

1 reads

RE: Convert ASCII

• by AnzioBake

• SQLServerCentral.com

• Reply

Not Entirely sure what you want but try this: It Will give you the ascii number represented by the hexadecimal number declare @s1 varchar(2) ,@ii int ,@bin varbinary(10) set @s1='14' set @bin = 0 set @ii = 1 While @ii <= Len(@s1)Begin Select @Bin = @Bin +( Power( 16, @ii - 1 ) * Convert( […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-09