Search:
Type: Posts; User: ober0330
Search:
Search took 0.34 seconds.
-
Well considering that I refuse to force my users to use IE and I wouldn't dream of using .NET, I'm fine with pulling that info out of a LDAP table based on the login that they use.
Plus, you're...
-
Nevermind, I got the result. There is a 'mssql_rows_affected' function that returns the number of rows affected by the last result.
:wave:
-
I have a bunch of data where I'm allowing people to mass-modify records.
Example:
Contract A - active
Contract B - active
Contract C - not active
The 'active' field is a select box and they...
-
The crazy thing is that the functionality provided by the trigger is both inefficient and bad design. So add bad design on top of a flawed method of getting work done and you create a nightmare.
...
-
I wasted a ton of time on this yesterday.. should have come here first. It was the trigger. Thank you all!
-
Oh wait, you meant trigger... not SP. Looking at the one trigger now.
-
Hmm... didn't think of that. There are 43 stored procedures in the DB... any way to query those without looking through all 43??
-
And if it helps, I'm using a global sa role in my connection string.
-
SQL statement: UPDATE DTPROJECTTRACKING SET Time_Unit = 1 WHERE CONTRACT_ID = '08132'
Here is the table:
CREATE TABLE [dbo].[DTPROJECTTRACKING] (
[Contract_ID] [nchar] (32) COLLATE...
-
So I have MSSQL Version 8 (I think that's 2003). This database is used with an old .NET application that I'm currently rewriting in PHP. Most of that is irrelevant, however.
I use one user to do...
-
Ugh... I can't see how anyone would willing code in this crap. Why do I need all these files and project crap? I just want a basic connection to a database and some simple class support. WHERE'S...
-
-
Alright, I'll give you a little background. I'm a PHP Developer being forced into an ASP.NET world... all I want to do is create a simple OOP approach to layout (header/footer/session management...
-
Actually, I found somewhere else how to add a function to a module and then create a custom button to run that. :)
Thanks.
-
Anyone know how to trigger a form/macro to automatically load when you open an Excel sheet?
I hate VBA... but it's all I have ATM.
-
Speakin to the choir, friend, speakin to the choir ;)
-
I already have the database created. But there was a table that I missed when I ran the DTS. I just want the CREATE TABLE SQL from Access for that table. And if nothing else, just for my own...
-
Running Access 2K3 and moving a database to MSDE. All I need to do is get the CREATE TABLE statement out of Access for a table. I don't want to transfer the data, just the structure.
Can someone...
-
Ok... but every minute after 7AM, that's going to run. How do I only get it to run once? I'd have to set it so that if it's 7:00 and not worry about the seconds.
-
I have an application that runs 24/7 and there is a procedure in that project that can be run by the press of a button. However, it needs to be pushed at 7AM every morning and I want to automate...
-
I guess I'm just trying to avoid a beefy process in the background along with having IT come out and take care of all the updates.
-
And I think that's why I'll be using MSDE. I'm not going to create the hassle that would be involved with installing SSX.
I really do appreciate all the input though (from both of you), it's been...
-
True. And that's probably all correct. It's just that the PCs I'm setting up are in a very tight/controlled environment and they run very expensive test software and I'd like to keep the...
-
What if I don't need all the new functionality? I just need a very simple data storage tool that isn't Access.
*sigh*... I just hate the idea of installing all that upgrade stuff on the PCs I'll...
-
Then why are they 2 different products? Seems kind of ridiculous.
Besides, why should I install SQL Server Express when it requires .NET 2, MSXML6 and XP SP2 to even function? MSDE works...
-
So let me get this straight:
With that method, all I have to do is create the MDF file in SQL Server express and then include the MDF in the install of my VB app? And I have full functionality to...
-
Ok, I rebooted and it's all up and functional now. Nevermind. Thanks for the help!
-
***... Ok, I downloaded it, put the batch file in the folder, changed the locations, and it ran like it installed it. The files were created and I have the master database, etc. When I try to...
-
OK, new question... how do I use Enterprise Manager to connect to a MSDE instance? Do I register a new server???
-
Ok, nevermind... I found it and I'm installing right now. Thanks for your help... it's been invaluable!
-
Ok... and I guess the MSDE executable is something I can download from microsoft.com?
And I don't need stored procedures... I just need a few tables that I can grab data from, update, and insert...
-
Hmm... and you can use that database just like you were running it off of the full SQL Server (queries of all types?).
What setup.exe file are you talking about? And I have the Enterprise...
-
Unless you're referring to the "Linked Servers" thread, I don't see what you're getting at.
Besides, I plan to do the update of the global server through VB, since I don't really have control...
-
OK.... I will in a bit. S*** just hit the fan here.
-
Yes, that's correct. Can you point me to where you made these comments?
-
The project is 90% done, but I'm doing some database re-write and upgrade from Access to MSDE. I downloaded and installed SQL Server Express yesterday and I'm about to test the connection to the...
-
Thanks for the input. I assume connecting to and dealing with Express is the same as Enterprise?
EDIT: And I changed my location :p
-
Sup sal? :)
Well, I guess the thing is that I don't want to have a server running in the background all the time, unless you can tell me how to start and stop it. I just want a database that I...
-
-
Well, the problem is that the software running locally will often be running without a connection to the global server, hence the need for the local version. It's not a question of global vs. local,...
|
Click Here to Expand Forum to Full Width
|