RE: Fail Transfer database properties
Can you post more info? What error message you received? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-07-12
security
RE: Login fails
Yeah I'll have to drag them out of the closet, first I want some NT gurus look at. It's too wierd. On the client that's not part of the domain I connect to one of the SQL servers but not the other, and on the one I connect to event log on that server keeps […]
2003-07-11
RE: Login fails
One last thought. I don't want to steer everybody helter skelter. Have you installed Desktop Engine SP3a? All the best, Dale Edited by - dalec on 07/11/2003 1:04:16 PM
2003-07-11
RE: Schema Binding...7/11 question
🙂 Done it myself a hundred times. Actually, it's on my list to add the multiple answer questions. Right now, the only way I have to ask that type of questions is to add the operative not phrase. Brian Knight bknight@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bknight
2003-07-11
RE: Problem creating index due to column stats
Yes you are right, SQL Server creates these to keep track of non-index statistics on columns, to capture the statistics even though there is no physical index on that. Since these are not real indexes you cannot use DROP INDEX, you must use DROP STATISTICS. But again it is not a good idea to drop […]
2003-07-11
RE: running external apps from sql server 2000?
I have the following command: exec master.. xp_cmdshell ' \pcplus\refiner.exe' to run an application. when i execute it query analyser crashes. Any ideas why? If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!
2003-07-11
Review: AppDetective Helps You Be a Nosy DBA
So how many servers do you have in your environment? In this review of AppDetective by Brian Knight, he shows you how AppDetective helped him find SQL Servers he didn't even know about in his environment.
2003-07-11
4,700 reads
RE: Launcing DTS packages from Stored Procedures
If you are having problems running it from the stored profcedure, but you can run it fine from Query Analyzer, check to see what account your service is logging in as. You may not have access to the DTS file with the account that the service uses.
2003-07-10
1 reads
RE: SQLServerAgentMail and Lotus Notes, not paging
Have you verified you can send mail from the server logged in under whatever account the agent runs? Getting any errors when you try to run xp_sendmail? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-07-10
RE: New security hole
quote: SP4 has a lot of security patches in it. Just look at the slew of advisories that flew from Microsoft yesterday. I only received one. What 'newsletter' have you subscribed to? Cheers, Frank
2003-07-10
Blogs
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Monday Monitor Tip: Compliance Checking for Old Versions
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
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