Viewing 15 posts - 16 through 30 (of 37 total)
I decided to go with adding a bitmask to the parameter table and have now found the following code to return the bit('s) that are currently set.
November 17, 2003 at 3:52 am
Problem solved....
I have creates a stored procedure to check the sysprocesses against the Workstation ID table and scheduled this to run every 10 mins (a bit excessive but it stops...
November 6, 2003 at 9:19 am
We have a similar situation here with departments writing their own access applications and then the person responsible leaves...
it then falls on the IT department / DBA to pick up...
October 22, 2003 at 2:01 am
The way i check for the mdac version is by doing the following
copy the code below into notepad
dim oConn
set oConn=CreateObject("ADODB.Connection")
msgbox "Mdac Version = " & oConn.version
set oConn = nothing
save it...
October 8, 2003 at 2:03 am
It would also be usefull for those who had bought the software to make others aware of its limitations within SQL i.e. requiring the user to know the SA password...
September 26, 2003 at 5:27 am
You could also use crystal reports from within VB (see the crystal decisions website), but beware!! there are issues with licenses if you want to publish these reports on the...
September 16, 2003 at 1:40 am
Well I think I have got to the bottom of our disk thrashing problem...
The problem did not occur at all on friday..No changes have been made to the server..
The...
September 15, 2003 at 4:39 am
Vladan,mdamera, e.t.c
Out of interest
How many databases, What sizes , and how many transactions per second...
This information would be of some help in proving my case if push comes to shove.....
September 12, 2003 at 2:14 am
quote:
if you listen carefully) hear the satisfying thud of leather on ass of the individual concerned
September 12, 2003 at 2:00 am
Another thought
I remember I was at the Visual Studio .Net launch in london and Micro$oft were going on about the performance increases to be had from using a RAW partition...
September 11, 2003 at 8:34 am
This thread could not have come along at a more apt time.
Situation
Our Production Sql server is exhibiting Network Locks and pageiolatch_sh locks.
the configuration of the diskc is a single RAID...
September 11, 2003 at 8:28 am
It depends ........
No honestly I agree with the fact that many developers are more knowledgable than the DBA (Hence I am both).
But the fact remains that 'Ignorance is the mother...
September 11, 2003 at 8:21 am
I am the SQL DBA & a developer as well ..
I am currently trying (without success) to lockdown all our SQL servers.. however
Everytime I restrict developers to read...
September 11, 2003 at 3:41 am
Another way is to Backup the database, use RAR to compress.
Email the file (depending on size) and restore on the client machine.
... shame you cannot use replication via email ..
Probably...
August 22, 2003 at 2:55 am
Viewing 15 posts - 16 through 30 (of 37 total)