|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 How do I resolve roles with just the userid (uid) in the sysusers table ? Posted by steve mew at 6/19/2004 10:31:03 PM I have a reporting assignment that requires the need to find out which roles
a user has.
I have the userid (uid) and with this I can look up the user in the sysusers
table.
How do I find out what roles this user has ?
Any help greatly appreciated.
Thanks
s
...more >>
SQL Server and COM+ Security Posted by Kristian Aasbjerg at 6/19/2004 6:43:02 PM I have for some months by now tried to decide where to enforce security on a new application we are starting up. The suggestion is - of course - to enforce security in the middle tear (COM+), but what REALLY bugs me is, that there is no guidelines on how to make your connection in Visual Basic! I ca...more >>
How can I know the table size ? Posted by Agnes at 6/19/2004 5:39:14 PM I am using vfp before, as i design the table, i know how large of the
tables.
e.g 35 fields, 680 bytes
Now, how I can know it in SQL ?
Thanks
...more >>
Adding DateTime columns Posted by John at 6/19/2004 5:29:34 PM When I add two DateTime columns together in a View (One column has just the
date and the other just the time), I get the right time but the date is two
days earlier than in the database itself. So if the date is 15/06/2004
(dd/MM/yyy) in the database and the time is 13:45, then the column resulti...more >>
Find References to Deleted Field Posted by Fred Nelson at 6/19/2004 4:00:33 PM Hi:
I deleted an unrequired field from a record in my database and I obviously
have some reference to it in one of my 70+ stored procedures. I've been
through all of them twice - I'm sure its there I just can't find it.
Is there an easy way to search all stored procedures for a reference - ...more >>
Massive DTS job (5 days and i am nervous) Posted by N at 6/19/2004 2:34:15 PM Hi
I have inherited a DTS job that takes about 5 days to run.
This job is made up of about 20 stored procedures and some vbscript and so
on.
There is a bit of a process log that is kept in a table which is basically a
log of a start of a stored proc and then logs an end time for the stored
p...more >>
How to log bad logins? Posted by Just D at 6/19/2004 2:28:09 PM Hi,
Does anybody logs bad logins to the SQL Server? If somebody tries to login
from some IP address I need to get all these tries logged somewhere on the
server. What are possible ways? NAT, Firewall, some other kind of logger
installed on SQL server?
Thanks,
Dmitri
...more >>
stop sql injection Posted by Aaron at 6/19/2004 10:26:48 AM Is there a way to disable the use of -- and ; in a sql query? i think this
would prevent sql injection attacks. I'm using sql server 2000
Thanks,
Aaron
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
GROUP by, but not exact... Posted by Mario Splivalo at 6/19/2004 9:27:58 AM The table looks like this:
docId itemId priceId qty price
---------------------------------------
DOC01 1 1 1 10
DOC01 1 2 1 10
DOC01 1 3 1 10
DOC01 1 4 1 10
DOC01 1 5 1 5
DOC01 1 6 1 5
DOC01 1 7 1 10
DOC01 1 8 1 10
DOC01 1 9 1 6
DOC01 2 1 1 10
DOC02 2 2 1 10
DOC03 2 3 1 5
....
d...more >>
Changing the RULE by updating syscomments Posted by leonidbogdanov NO[at]SPAM decadesoftware.com at 6/19/2004 9:20:28 AM MS SQL Server2000, sp3:
I have a datatype and a rule bound to it. The dataype is used
everywhere in the database. I need to change the rule and I want to
avoid unbinding, recreating the rule, and re-binding.
I updated syscomments table (ctext column) by the new rule definition
and it seems wo...more >>
SQL Server and Spoolfile? Posted by John A. Horve at 6/19/2004 7:42:51 AM Hello,
With Oracle you can create a spoolfile
...
spool c:\test\spool.log
SELECT * FROM employees
spool off
....
You can also run this file inside the SQL:
@C:\Test\spool.log
Is there anything like this in SQL-server ?
regards John
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |