Yes I was referring to vb.net in this instance.
I found out what I needed to know, thanks all.
Hey rickyoswaldiow,
I see we share the same last name.
I have a brother named Rick.
small world.
bob
Hey Vongrut,
That is the exact code I was looking for.
I knew it could be done directly in sql but just didn't have the expertise to make it work.
Abaldwin, take a look at his post because that is the solution right there.
Thanks to all of you for helping out!
bob
Alex,
But I will also have recs that aren't in order with no breaks in coverage like this...
ID Start End
1 1/1/2006 2/10/2006
1 2/11/2006 3/12/2006
1 4/1/2006 5/15/2006
This should be made into 2 records, so I need something different than what you sent me to...
I have a table that will have a start date, end date, and a third field called ID. If when going through this table that is indexed by ID, start Date, I want to take all the fields that have no breaks in the date fields to be combined into 1 record where possible. For example, I have 3...
Line 60 is the select statement that was processing when the connection was broken. It is almost as if there is some type of threshold being met that is causing the connection to be broken, like a timeout or something, because this only happens with very long running queries, but if I run that...
We are on Windows Server 2003 with SQL Server 2000 Database and when running a bat file using ISQLW (which is the same as running Query Analyser) I will sometimes get the following error after being connected for a few hours already, for some reason the connection gets broken and this error is...
I am trying to run the following command...
Alter Database MYDB Set Restricted_User With Rollback Immediate
When I run this command it works great except for the users that connect to that SQL Server 2000 server via a CITRIX connection. I can kill thier spid also and I believe the Citrix server...
I have a table that contains a BeginDate field along with a Plan_id field that we will use to sort recs. What I want to do is add a EndDate column to this table or create a new table with Plan_id, BeginDate and the new EndDate column.
The current table will be sorted by Plan_id and BeginDate...
When I run this command to prevent users that have read only type permission..
ALTER DATABASE Roster SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE
Any login I create with SQL Server authentication is prevented for accessing the database but, if the user login is created using Windows NT...
All our SQL Server 2000 users are in a Read-Only group named Readers. Is there a command that will prevent any user in that group (Readers), from being granted any Lock on any Object between 3pm and 4pm?
I need to accomplish the following;
1. Any users that are active when my script is...
mrdenny,
We sure do have a firewall to go through. Thank you. All I read is not to start messenger is pc is used to get on internet. No explanation though.
Can you tell me how turning the messenger on would be a potential security risk without the firewall?
b
Hi All,
I have a script that will log off any active users on SQL Server 2000 that happen to be using a particular database between 5 and 6 pm.
I was going to use xp_cmdshell to launch an informational message that will pop up on their screens letting the users know that they will be logged off...
Can someone tell me how to get the syntax right for the following cmd in Query Analyzer...
set @cmd =
'OSQL -Uusername -Pmypwd -Q"select * from table"'
I have tried many combinations without any luck using single quotes so that it will work in a SP.
We have a program that runs at 5pm each night for around 15 minutes. Sometimes if users are on the system and accessing any of the three tables that the 5 pm program updates, the updates will fail.
Lets say the program updates tableA, B, and C.
Is there a way to write a script that says get...
NoCoolHandle and SQL Sister,
Thank you both for this invaluable information.
My dilemma is that we have an application for which we don't own the source code, otherwise I would lock these tables exclusively for the 20 minutes that the code runs and release them when finished. There are only 3...
We give our users read only access to the reporting repository on SQL Server 2000.
Can you tell me how a user with this type of access could ever get any type of lock on a table, page or database?
Also, if a read only user is in a table will it prevent a program that has write privleges from...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.