Search results for query: *

Is there a simple sp that can tell me if the currently logged in user has db_owner rights? We run an app that performs DB changes when necessary, but want to ensure only a member of db_owner performs the changes. VB app runs against sql2000, uses windows authentication. Thanks Paul

I have a new application in VB that uses MSDE2K and am packaging using Wise Installation System. What is the best way to provide a demo DB for the installation? 1) Backup/Restore script or 2) Create table script and read data from text file, 3) Something better? Thanks

Read some threads but can't get sure answer if they can co-exist. Running SQL2K-DEV on laptop and want to port/test our app to MSDE2K. Can it be done? Thanks

We have a W2K3 Server (test) hosting a .ASP web site. It makes calls via ODBC to a W2K server hosting SQL2K. W2K3 site requires NT Authentication for login, but seems to be passing Anonymous Login to SQL on it's calls? I have the exact same setup on a .ASP web site running on W2K...

Creating a new SQL2000 server. Maybe I'm missing something, but how do I transfer Stored Procedures from SQL7 production server? Everything seems to transfer except the SP. Thanks

I have a COM dll that returns a variant multidimensional array. For example ..data type shown in () aR(0,0) = COMPANY NAME (string) aR(0,1) = COMPANY ADDRESS (string) aR(0,3) = YTD REVENUE (Double) aR(0,4) = MTD REVENUE (Double) aR(0,5) = ACTIVE (Boolean) then aR(1,0) = same for the next client...

Any recommendations on whether it's acceptable to run Domain Server, IIS and MSSQL 7 on same server, or should they be broken out across different machines? Currently Win2K Server and intranet has 7 mixed Win2K/XP clients, and we have another 12 clients that access IIS from internet. Currently...

I have seen this answered before, but cannot locate the post. We have a web site ie.. http://www.oursite.com. How do we configure IIS so that we can use this URL to view the site from within the network? Right now we can only access it by putting in the ip address of the server. 192.168.2.101...

Microsoft has issed a Critical bulletin covering most Office and VBA SDK's on Sept 3. Here is the link. http://www.microsoft.com/security/security_bulletins/ms03-037.asp

We are considering putting up an FTP site for our clients. Are there any "better" yet cost effective FTP software other than what IIS can provide? Security would be a chief concern. Thanks for any advice. Paul

A post has been added to the FAQ section on POST-SP4 fixes from Microsoft. Check there to see if any problems you are having since installing SP4 on your WIN2K system are listed with the appropriate fix(s). Cheers!

Some sites have started to compile a list of bugs/problems etc... with SP4. Here's one that may point to a problem you are having. http://www.w2knews.com/anecdotes.htm Paul

We want to open up the access to our internal network from the internet for AD users in our network. We are currently using PCA with a single user login abillity. We want to know if a VPN would... 1) Be more secure than PCA 2) Have quicker throughput than PCA. Thanks for any replies. Paul

We want to move our PDC to a new box. Our server network consists of 1 PDC, 1 Web Server, 1 App Server and a test server, all running Win2K Server. Can someone suggest good reading or good advice on how to move the PDC to a different box without loosing any information? Thanks, Paul

Since installing SP4 on one of the Win2K servers, I get a regular error showing up in the event logs every 1/2 hour. "Listen failed: 15" Cannot seem to find any info on this. I am running a restricted web site on this server. Any ideas? Thanks Paul

In our IIS logs, we show date, time ip address and HEAD. What does HEAD mean? After HEAD there appears to be an attempt to run CMD.EXE or ROOT.EXE from different folders, including system32, scripts, _mem_bin, _vti_bin etc... In all cases the result code was 401 access denied. Thanks Paul

Can someone let me know if the following will work? I have 1 win2k PDC, 2 win2k file servers, 1 dsl modem & router and 8 mixed clients on the network. Router IP 192.168.2.1, PDC will be 192.168.2.2 and the rest will be DHCP clients from the PDC. Will the clients have problems going beyond the...

We are reconfiguring network from an NT4 server p2p with mixed clients to a Win2K AD Local Domain server with a router for external internet. What determines whether to use the Router DHCP abilities over the Win2K DHCP abilities? Also this is a small network with about 10 clients, should I just...