tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Connect

Sql 2K status lights...?

I am just a lonely System Admin but have a question on status lights on SQL
2K in my Win2K3 AD environment...
I have 2 domains in my environment.
If I register a SQLSVR using " the name of the server" to connect to
another SQLSVR in the same domain, SQL automatically connects to the other
server, no problem.

1/7/2010 6:35:49 PM

NNTP Clients

Network Buffer

We have a vb6 application that among other things queries sql server 2005 db
over lan. On the client side, where do I control the size of network buffer?
Thanks in advance

1/6/2010 5:35:01 PM

NNTP Clients

Triggers and String concatination

Hi all,
I am trying to create a Card Number for clients, after inserting a new
record, based on a clientID field
and the year part of the date:
CardNo = Year(Date) + PadL(ClientID, 7, '0')
PADL is an UDF to left PAD a string.
I wrote the following trigger, but I get an error when execute it:
++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++ ++++++++++++++++

1/4/2010 5:19:25 PM

NNTP Clustering

Shared Disk and Active Node in SQL 2000

I need to know the active node in case of clustered SQL 2000 from any of the
participating nodes for a particular SQL Server instance.
A shared nothing disk array is a setup in which only one node can own a
given resource at any given moment. All other nodes are denied access until
they own the resource.

12/30/2009 7:02:01 AM

Clustering

Shared Disk and Active Node in SQL 2000

I need to know the active node in case of clustered SQL 2000 from any of the
participating nodes for a particular SQL Server instance.
A shared nothing disk array is a setup in which only one node can own a
given resource at any given moment. All other nodes are denied access until
they own the resource.

12/30/2009 7:02:01 AM

NNTP Clients

Problems with MS Access linked tables

Hello,
I don't know if this group can help, becuase I don't know if the problem is
with SQL Server, Windows or Access. I am hoping someone can identify the
problem and lead me to a solution.
This is Access 2000, Windows 2000 Server, and Possible SQL Server 2000 or
close to that year. The Access Database has been having occasional issues

12/28/2009 9:14:37 PM

NNTP Clients

Access to Sql Query

This access query returns the result in a single row for each customer
SELECT NewTable.cid, MembersTable.Customer, Place.Place,
MembersTable.Tel, Max(IIf(NewTable.expid=1,NewTa ble.idno,0)) AS 1, Max
(IIf([NewTable].[expid]=1,Form at([NewTable].[NewDate],'mm/dd /
yyyy'),Null)) AS DateID1, Sum(IIf([NewTable].[expid]=1,F ormat

12/27/2009 4:50:41 PM

NNTP Connect

how to monitor the network?

I have windows desktop application which heavily depends on the network to
talk to the back-end SQL server.
how would you monitor this network, such as, connectivity, bandwidth, and
router changes, etc?

12/25/2009 6:02:01 PM

NNTP Connect

ALL IN ONE FOR YOU

please visit the sites
you get more informations,
IT informations,downloads,
etc.,
****************************** ********
[link]
[link]
[link]
[link]
[link]
[link]

12/25/2009 2:08:58 AM

NNTP Clients

read access via Access, unwanted CONTROL permission

I want to access a SQL Server table on a 2005 server via an Office Access
project (*.adp). Only read access is wanted.
It seems to be necessary to grant the CONTROL permission (besides SELECT and
VIEW DEFINITION) to display the connected table within Access.
Unfortunately I didn't found much precise information about CONTROL

12/24/2009 10:27:01 PM

Clustering

Find active node name in SQL 2000 Cluster

I have an application that connects to SQL Server clustered instance and
works based on the fact whether it is installed on active SQL node or passive
SQL node.
I have found fn_virtualservernodes() function that returns the list of
failover nodes. I have observed that the first node returned by this

12/24/2009 5:57:01 AM

NNTP Clustering

Find active node name in SQL 2000 Cluster

I have an application that connects to SQL Server clustered instance and
works based on the fact whether it is installed on active SQL node or passive
SQL node.
I have found fn_virtualservernodes() function that returns the list of
failover nodes. I have observed that the first node returned by this

12/24/2009 5:57:01 AM

NNTP Connect

tALL IN ONE FOR YOU

please visit the sites
you get more informations,
IT informations,downloads,
etc.,
****************************** ********
[link]
[link]
[link]
[link]
[link]
[link]

12/22/2009 6:00:24 PM

NNTP Connect

Invalid connection string attribute Error

We recently upgraded our SQL 2000 database to SQL2005. We have several COM
objects, written in Visual Basic 6.0, using a basic connection string to
connect to the database. We installed the SQL native client on the Windows
2003 Server running the objects. All objects use the same code to connect to

12/22/2009 2:53:01 PM

NNTP Clients

About access to Sql Server

Hello!
Assume I use Integrated Security. I have two windows accounts one account
Tony that I use when logging in to the machine and the other is ASPNET that
IIS is using.
Now to my question will these two windows account(Tony and ASPNET) have the
same access rights to Sql Server ?
I mean that every windows account that you use with Integrated Secirity have

12/22/2009 1:56:24 PM

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 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 56

pBlogCategories

sys.books