RE: Filtering data ??
In Analysis Services Manager, click on your cube, choose Edit and set the Source Table Filter property...that should do it! hth, Michael Michael Weiss
2003-04-29
security
RE: searching with like for ]
As I said earlier, before executing the query replace all [ with [[] Do not replace ] with []]. Keep them as it is. For your example "a[k']p" becomes "a[[]k']p" So searching in database for "a[[]k']p" retrieves the records with "a[k']p"
2003-04-29
RE: Backup strategy
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-04-29
RE: xp_cmdshell, DIR and remote machine
Andy, I guess I'm now confused. I know there are two service accounts, one for MSSQLSERVER, and one for SQLSERVERAGENT. Now I always thought if you run JOBs that execute xp_cmdshell that the xp_cmdshell commands are run under the MSSQLACCOUNT account, and when you execute an xp_cmdshell command via QA (which is what Szymana is […]
2003-04-29
1 reads
RE: For the love of...
Thanks for your response folks. As far as the form submission is concerned, there isn't one to worry about with this one so we can rule out a validation or re-submission error. With regards to your suggestion Andy, I've placed a response.end statement directly following the call to the stored proc, ensuring that it is […]
2003-04-29
2003-04-29
1 reads
RE: removing local admin group
Also make sure you have the appropriate accounts specified as sysadmin fixed server role members before dropping BUILTIN\Administrators. Last thing you want to do is drop that group and then realize you don't have access back into SQL Server. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-04-29
RE: how would You determine the fields in a PK?
look at query #4 in http://qa.sqlservercentral.com/scripts/contributions/246.asp best regards, chris
2003-04-29
2003-04-29
RE: OpenRowSet/GetDataSource
I've used it, so I know it's possible. Are you absolutely sure you do have permissions to access the file on the UNC path? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-04-29
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers