I've got a tool that accesses syslogins to pick up some information.
When I run the tool, I get the error message that sasys that my login
does not have sufficient permissions to read syslogins. If I run under
my admin ID, everything is fine. HOWEVER, the intention is that this

In VB 6, using ADO, SQL Server 2000
In my VB program I use the connection object (abc)
to begin a transaction.
abc.BeginTrans

I've only ever used built in SQL Server tools but have been looking at
log tools. I looked at Log Explorer 4.02 from lumigent.com and was very
impressed with what I saw. The prices tag per instance was a bit hefty
I felt though. I've been over to LogPI.com and am reading some of the

I'm using SS2K on W2K.
Brieffing: Many months ago, I created a stored procedure only used by those
with admin rights in SS. Now, someone else (without admin rights) has to run
it. I gave him rigth to execute the SP but, at the second and more

I have 2 procedures setup in master database, sp_RebuildIndexesMain and
sp_RebuildIndexesSub
The Sub just shows and execute DBCC commands for passed database
context

I have a question I hope somebody can help me.
In a SQL db I must store in row PDF files which can grow without any basis.
I know due to bibliography that you are allowed to store up till 2GB binary
data. Due to that fact there will not be any problem, because the PDF files

Assistance Please
I have a couple of scheduled jobs that are failing to e-mail
notifications on completion (via SQL Agent Mail).
I can send a Test e-mail without any problems. I can run the jobs

In my database client application (C#) I sometimes get an exception telling
me, that my application (which runs a some kind ob batch job) was selected
as deadlock victim and the active transaction was terminated.
No I want to get mor information about, which other application ...

we have a SQL2000SP3 runing in W2K3.  The application is JDEdwards.
recently I've observed that once in a while (about a few hours), there
would be a process from the ERP application that holds quite a number
of extent locks in tempdb, can be as high as 10000 locks.  when I run

I was hoping someone could help me with what I'm sure is a very simple
problem...I just can't seem to find the syntax!
I'm wanting to update the rows in 'tbl_consolidate' from 'tbl_hold',
but working through the records in 'tbl_hold' in the order of dates in

Hei!
I am getting this SQL error when i tried to use SQL Query Analyzer,
Unable to connect to server AxpServer1
Server: Msg 18456, level 16, state 1

I am trying to restore a database from backup on another system [my
client's] but I had to follow some weired steps.
Step 1. Restore the database from EM 's GUI.
[Users as on My machine get restored but their logins are not

can i please have some assistance around performing a sql query that inserts
data based on a date range.
for example my initial query is
INSERT INTO tbl_master

I am new to SQL server but I need to figure out how to monitor the contents
of a folder then move files from this folder to another folder when a new
file shows up. I do have experience with VB script and VB.Net and have
created both a script and an exe that do what I need. The ...

I have a SqlServer 2000 running 7 databases.  One in particular is slower
than the rest specificaly on certain tables.  It seems the problem comes
from the volume of data, but I don't think 3000 lines can be considered a
big table.  I have indexes on the principal keys, but it ...