Search results for query: *

Actually it is a Win2000 Server, not NT4... Any other suggestions?? It has the valid NTDS Setting in Sites and Services and is set to hold a Global Catalog... still only reports as a backup (and there is currently no other box running AD right now).

The box that was serving as my Primary Domain controller died. I did have AD running on another box. That box, however, is still showing in net accounts as a backup, not the primary. Now since nothing is acting as a "primary", my trust relationships with other domains are down. How...

I am needing to create a new Transaction log (had a power glitch mid process, now I get an "invalid LSN" message). Knowledge base says that SQLServer "sometimes" creates a new log file if the original file is renamed or deleted. How do you MAKE it create a new log file...

I heard in the summit for SQL2000 that there are places in 2000 that you can use VBScript. I am still in the world of SQL7 and haven't had a chance to play with it yet. SQL does, however, have similar functions. IsNull works the same with the addition of a parameter (look in books online --...

If you are wanting to link data in Table 1 from DB1 with data in Table 1 in DB2 then use the full DBname path in your SQL join statement. For Example: SELECT * FROM DB1..Table1 a JOIN DB2..Table1 b on a.linkingfield = b.linkingfield.

I have a table in which I want to store tif images to be pulled into a Crystal Report as an OLE object with other corresponding data. I have been browsing and browsing through the OnLine books, but can not find out to insert the file or even a link to the file. All I can find is inserting text...

I am creating a report with data coming from SQLServer. Part of the report is including tif images that support the data in the report. The file name is in the database. I can see how to create a hyperlink to the file dynamically, but it only creates the link... it won't print the image that...

The MAPI dll will help read the message and read and save the attachment information, but it will not allow me to modify its "Read" status (this property is read only) to keep me from processing it again, nor will itlet me save it to another folder. Any other suggestions or ideas??

I am trying to write an app that downloads emails, then copies the attachments/starts processes based on who the sender is, and then saves the entire eml to a particular folder. The MSAPI doesn't cut it. Are there any other APIs or ActiveX objects that will help me gain full control of an...

I have some VB modules that I am wanting to execute in VBScript (system redesign). Some of my modules, however, use the GOTO command to jump around in the code. I cannot execute these scripts in VBScript. Is there a similar command/function in VBScript or am I forced to find new logic??

I have an app with a custom login form. The connection string contains the username. However, whenever I execute a statement (or even return a recordset of "SELECT user", I get back "dbo" instead of the user name. I have some triggers setup that populate an activitylog to...

AaronA -- That was it. Thank you very much. That question has loomed for a while and have not had a chance to figure it out. Thanks for saving me the time!!!!

No, SQLServer can accept both NT and SQL security accounts (Mixed Security Mode). This is on SQL7. You can assign user names to the database which can be different from the login name (the login for an NT account is Domain\LoginName, but in each database, you can give it an aliased UserName).

I have a custom login form in my VB app. The user types in their username and password which I then include in my ADO connection string to my SQL Server. The problem is, it will only recognise SQLServer security accounts. Any login that is set up as an NT User, it will not recognise and...

FYI - bulk copies do not make entries in the transaction log.

One warning about using foxdev's "select into" idea. A select into statement will lock the table you are selecting from until the operation is complete, so I recommend doing that afterhours. If you can't wait, then create the table and just append into it, as suggested by foxbox.

One way you can do it is in the Form_Load sub of your switchboard form you can go ahead and open a connection(ADO) or workspace (DAO) - whichever protocol you are using. If you wanted to make it cleaner, you could also create a login form that will load first (before Switchboard). Have the...

The choice of Access or SQL depends on anticipated size of data as well as how much you want to spend. SQL Server is obviously more expensive, but if the project and dataset is large enough, it is more justifiable. No, the users will not need Access or SQL on their machines. If you go SQL...

You're not far off. I believe the syntax you need is: UPDATE demo SET demo.region2 = mhrsDemo.region, demo.mhrs = mhrsDemo.mhrs FROM Demo JOIN mhrsDEMO ON Demo.Id = mhrsDemo.Id

Our company uses a custom VB app that utilizes the pkzip and pkunzip command line utilities. These don't seem to work on the few test stations we have migrated over to Windows 2000 Prof. Is there a newer utility that can be used inside the program to compress or expand zip files??