|
|
|
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 |
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 31 Getting the sa password with SQLDMO Posted by Otis at 12/26/2004 10:47:31 PM Hi,
I have a failsafe routine that checks the sa password to make sure that it
has not been changed. I can reset it like this:
If objLogin.Name = "sa" Then objLogin.SetPassword vbNullString,
"Somepassword"
But it seems a little sloppy to be setting this password again and again
when it n...more >>
Different where clause depending on parameter values Posted by larzeb at 12/26/2004 3:32:42 PM The following SP had 3 parameters. The first one is never NULL, but
the 2nd and 3rd may be NULL. I do not know how to it other than the
illustration below.
Any suggestions? TIA
Lars
Create Procedure abc
@A int,
@B varchar(10) = NULL,
@C varchar(50 = NULL
AS
IF @B IS NULL AND @C IS...more >>
How to drop distribution database? Posted by Przemo at 12/26/2004 2:07:03 PM After disabling publishions and distribution on a server there still is a
database "distribution" which cannot be dropped or deteached due to Error
3724 "Cannot drop database because it is being used for replication". But
there is NO replication on this server.
When I configure server for p...more >>
SQL Syntax Help Posted by NathanV at 12/26/2004 1:09:01 PM I need some help with a SQL statement (SQL Server 2k).
I have three tables, an Artists table which holds user info, a Types table
which holds the TypeID and Description for different types (I.e. visual,
musician, etc) and an Artists_Types table, which stores Type_ID information
for each A...more >>
Combining rows Posted by RickN at 12/26/2004 10:27:01 AM Need help writing a SQL command to do the following
I have two tables, TableA and TableB
Table A has three columns:
code sequence description
and values:
1, a, descparta
1, b, descpartb
1,c, descpartc
2, a, descparta
3,a,descparta
3,b,descpartb
I want to combine all the description valu...more >>
View Diagram Pane - how save layout after I change it? 2000 Posted by L Mehl at 12/26/2004 9:39:15 AM Hello --
Is there a way to configure 2000 so it will save a view layout after I
change it in the diagram pane?
Thanks for any help.
Larry Mehl
...more >>
Transaction replication problem Posted by Przemo at 12/26/2004 9:33:02 AM Hi,
I am configuring transaction replication on 2 computers, using no-doman
accounts. Account I use is the same on 2 machines, same are passwords.
SELECT @@servername is properly executed on these 2 computers
Distributor and publicator configures with no error. When I add a
publication, dur...more >>
temp table troubles Posted by Nickl at 12/26/2004 6:15:02 AM I am trying to create a temp table using dynamic SQL in a stored procedure. I
then would like to reference the temp table in a second Stored Procedure
using a cursor to Wrap each record in XML tags (there is conditional
variation between the records, hence the cursor). I am able to generate th...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Changing account for SQLServer problem Posted by Przemo at 12/26/2004 4:27:01 AM Hi,
I cann't change account for sqlserver service as well as for a sql agent to
different than System. I get a message that such a account does not exist.
But it really exists. Previously I have changes WindowsXP computer name and
this problem occured immediately after that.
Przemo...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |