Viewing 15 posts - 5,611 through 5,625 (of 6,105 total)
I'm basing this query on the fact that you know the first 3 octets (and therefore know the length), and you are only trying to sort on the last octet:
February 16, 2002 at 3:09 pm
We had this problem when trying to install SQL 2K on a box where we had already remapped the drives... we didn't have time to figure it out (which is...
February 16, 2002 at 10:18 am
Auditing can be turned on for both SQL Server 7 and 2000 for NT users. Results will show up in the Security Log on the system. However, if...
February 16, 2002 at 10:03 am
Try BabelFish from AltaVista. It can do translations of web pages including SQL Server Central's. Given, it's a rough translation, but it does do them. And it's...
February 16, 2002 at 9:49 am
Then there's the saying that goes something like: When you finally make something idiot-proof, they just go and build a better idiot. Unfortunately, these words seem very, very true.
K....
February 15, 2002 at 11:50 am
Are the user accounts SQL Server based on Windows based? If they are Windows based, there are some things that can be done to find out the last time...
February 15, 2002 at 11:48 am
This doesn't sound like a very efficient process, but if they are editing row by row and they simply enter end in a field on a new row, a trigger...
February 15, 2002 at 11:46 am
Or your wife asks you to figure out which kids want chocolate ice cream at the birthday party and you instantly start coding the query in SQL.
K. Brian Kelley
February 15, 2002 at 11:43 am
You're suffering from that problem, too? I've got three different systems up at my cube (1 desktop and 2 laptops) and am active on all of them at the...
February 15, 2002 at 9:24 am
That makes sense since the system tables work off smallint for uid in order to join back to sysusers. But always better safe than sorry.
K. Brian Kelley
February 15, 2002 at 9:17 am
quote:
Some times, I think part of the problem is (at least for our SQL dept) is that we're not given enough time...
February 15, 2002 at 9:15 am
quote:
But deny would be taking the check box out, revoke is an X ad grant is a check
February 15, 2002 at 9:07 am
As with anything else, standards will have to be established. It wouldn't surprise me if most organizations open up VB.NET and C# (meaning a DBA will need to learn...
February 14, 2002 at 7:51 pm
To add more fuel to the fire, we do have an application group who did a similar method to what you are proposing. It did incur a performance issue,...
February 14, 2002 at 2:51 pm
Then there does sound like there's a user account issue. How was the database created? Scripted, DTS, backup/restore?
K. Brian Kelley
February 14, 2002 at 12:46 pm
Viewing 15 posts - 5,611 through 5,625 (of 6,105 total)