Recent content by faccorp

thanks everybody. kaht. Your method works very well. Thank You!

For each record whose type = 0 (parent records), there will be other child records that are associated with the parent record. I want to set the child 'AgingDate' to the 'DateTo' of the parent. Thanks

Hi, I'm looking for a better way to loop through a table. I'm using a Cursor and it's very slow. I know cursors are bad and I guess this is one reason. Here is my cursor DECLARE @idnum1 INT DECLARE @date1 DATETIME DECLARE my_sucky_cursor CURSOR FOR SELECT [MyTable].[ID Number]...

How would I deny Select statements on all my tables for all users? I can use DENY SELECT 'tablename' but it only applies to non-administrators. For security reasons, I only want a user to be able to access the data via the front end application. I am using Windows authentication...

Paul, Thank you. I will look into this. Ideally, I would like to create some other type of admin login/user that only I would know. Then, for maintenence purposes I could login to the server and make any necessary changes.

Thanks for the reply's. Here is some more information. I want the user to install the app. When the app runs for the first time it copies the shell of the database to the SQL Data folder and attaches it. After that, I don't want the user to be able to get into the database unless they're...

Hello everyone, I get a bit confused with setting permissions for my database. I am using Windows Authentication and a C++ front end app is connecting to a SQL 2005 database. Basically, in my front end, the initial user (who must be an Administrator of the connecting computer), creates a...

Well what the flippin crap is it good for then!? Are there other alternatives? I put a lot of code in my sp's to cut down on network traffic and make the server do all the tough work. Isn't that the whole intent. And yet there's no way to hide it and keep it safe?? Any other design ideas...

Thanks All. Dennis, when you say easily crackable, do you mean someone can figure out how to un-encrypt?

I have an SQL 2005 database with a front end written in C++. I am using all stored procedures and views to access the tables and I am granting execute privledges and select privledges on the views. I also need to allow users to create and alter views. I don't want the user to have the...

Hello, I have a Win2K3 server with SQL2005 Express installed. The server also allows VPN connections. From a remote computer, I can VPN without problem to the server. However, I get mixed results when trying to connect to the SQL Server. Usually it doesn't connect at all. If I play with...

The way I have done this in the past is to create another table that holds an integer value for each table. Every time a table row is updated/deleted/inserted, the integer gets incremented. Then, each client polls this table every 5 seconds. It retains the last value for each table and if the...

Bill, Thanks for the response. Sounds interesting. Surely there has to be a more direct method of doing this. Especially if there are changes being made all of the time. Thanks again.

Hello all, What is the perferred method of informing a client that a table has changed. If I have multiple clients viewing the same data, and one client changes data in the view, what's the best way to let everyone know that they should update their views. I'm using SQL 2005. I've been...

Thank you for your responses. After making some changes to indexes and relationships, the system appears faster, however, it doesn't seems too much faster than my Access database. A typical query on a VIEW that is accessing 3000-4000 records is taking about 1-2 seconds. The view is joining 2...