Viewing 15 posts - 5,986 through 6,000 (of 6,102 total)
quote:
For other professions, doctors, lawyers, accountants and engineers, the certification is statutory. That is, the government, usually states, manage the certification. With...
November 13, 2001 at 5:48 pm
Reaching here as well, but you said you tried a batch command and it failed... Can you successfully run xp_cmdshell from say Query Analyzer? Something simple such as a...
November 13, 2001 at 7:15 am
What version and service pack is your SQL Server? I'm assuming when you say you upgraded Enterprise Manager, you're speaking of a client system.
Also, under what set of client...
November 12, 2001 at 12:19 pm
I'm in the same boat as Steve. Have my MCSE, but haven't had the time to work towards the MCDBA. Good thing Microsoft decided to keep NT 4.0...
November 12, 2001 at 10:05 am
It's not the db, but the firewall/router where the access needs to be configured. Basically, an access list would be created that only a request to port 1433 from...
November 8, 2001 at 7:19 pm
We have been burned by people claiming certs, so we actually have set up a pretty rigorous interview as well. My manager is a developer (he's the resident VB...
November 6, 2001 at 9:18 am
How are you running isqlw? As a command line utility or are you essentially "shelling out" to it so that the user can type commands?
If command-line, here's something from...
November 6, 2001 at 9:05 am
How about apps that REQUIRE case-sensitive databases that are on the open market? There's a certain HR package that I've grown to loathe that requires case sensitivity. Grrr!
K....
October 29, 2001 at 6:50 am
Which version of SQL Server are you using? I'm assuming 7.0, but I want to verify. Also, are you using ASP, Cold Fusion, etc?
K. Brian Kelley
October 28, 2001 at 4:02 pm
If you are just looking at finding all constraints, regardless of type, use the INFORMATION_SCHEMA.TABLE_CONSTRAINTS view. It only returns information on objects the user has permissions to, but if...
October 24, 2001 at 10:23 am
I bought the SQL 2K book. It covers, as would be expected, some of the performance enhancements that are found in SQL 2K.
K. Brian Kelley
October 19, 2001 at 3:57 pm
This is because the 'PerformanceBased_PerCent' isn't yet available. The aliased field can't be used by your expression. You'll find that the aliased column is also unavailable in the...
October 18, 2001 at 11:50 am
Your first query:
quote:
SELECT *FROM tbl1
LEFT OUTER JOIN tbl2 ON tbl1.key = tbl2.key
WHERE tbl2.filter = 1
AND tbl2.key IS NULL
October 18, 2001 at 11:24 am
It sounds like your files are being kept on the filesystem and not as BLOBs. Is this correct? As Andy asked, what does SQL Server do in this configuration?
K....
October 12, 2001 at 7:15 am
Yes, indeed. I think the realization that many who were MCSEs had not completed recertification (myself included) would not do so by Dec 31 finally caused them to relook...
October 12, 2001 at 6:45 am
Viewing 15 posts - 5,986 through 6,000 (of 6,102 total)