Tag Info

Hot answers tagged

8

Don't plug-in their network cable, and turn off wifi.


7

RoboCopy is a command line tool provided by Microsoft that can do mirroring. The Wiki page also mentions a GUI.


7

Use SQL Server Agent to schedule the stored procedure that you call to make the backups. http://msdn.microsoft.com/en-us/library/ms189237.aspx


7

SQL Compact Edition: http://www.microsoft.com/sqlserver/2005/en/us/compact.aspx


6

Are you using Active Directory? Then you can use a Group Policy to change / add / remove Registry Settings for every user which logs onto a machine in the domain. If you cant use GPO maybe a shortcut to a script which sets the values in C:\Documents and Settings\All Users\Start Menu\Programs\Startup can help you.


6

It seams to me that you should ask yourself where the bottleneck is first. Most of the time SQL server is a hard consumer of disk IO; By itself this is a whole topic of optimization (Database Schema, SQL Query vs StoreProc etc.). You may want to use the SQL profiler. Are you using any state mechanism using the Web Service if so are you using SQL server to ...


6

By default in IIS, the App Pool will recyle after 20 minutes of inactivity (idle timeout setting). You can increase this (I belive setting it to 0 is the equivalent of setting it to never timeout). However, I think you'd be better off to look at the overall situation, rather than simply adjusting the idle timeout on IIS. How frequently is the service ...


5

Robocopy. Has options to copy various attributes including timestamps http://www.ss64.com/nt/robocopy.html Syntax ROBOCOPY source_folder destination_folder [file(s)_to_copy] [options] Key file(s)_to_copy : A list of files or a wildcard. (defaults to copying *.*) Source options /S : Copy Subfolders ...


5

Looks like the mail server is forcing this delay, probably in order to avoid spam: http://en.wikipedia.org/wiki/Tarpit_(networking). What mail server are you using? How is it configured? Are you using authenticated or unauthenticated SMTP to send mails?


5

That's exactly why all RDBMS have log files, so you can recover from disasters like these. For Sql Server 2005 start here with a log file recovery process. And here is another resource. The starting snippet from that article: A coworker calls you in a panic because he accidentally deleted some production data, and he wants you to restore the lost ...


5

It is really, really dangerous to run IIS as a user that has access to all folders in the file system. You are asking to be hacked badly (do you really want IIS to access C:\Windows?). It is better to explicitly grant permission to the user IIS runs under to access the folders you really need IIS to access. If you really must change the identity IIS runs ...


4

You could try using the undocumented /sm parameter for query session (in a batch file) to sort things more easily: FOR /f %%G IN ('query session /sm') DO tsdiscon %%G


4

We had a service that took a while to get started. Our fix was to spawn a thread and return immediately from the OnStart method. I'm not sure how well this will play with your dependencies issue, but it's certainly one way of sidestepping the 30second limit: protected override void OnStart(string[] args) { var thread = new Thread(() => ...


4

this works, googled "script list of adsi providers" WScript.Echo( listProviders() ); function listProviders() { var list = "ADSI Providers on this machine\n" ); list += "==============================\n" ); var ads = GetObject( "ADs:" ); var e = new Enumerator( ads ); for( ; !e.atEnd(); e.moveNext() ) { var mem = ...


4

You may only define one password policy via GPO for the entire domain. You may then set fine-grained password policies, however be aware that you do not apply fine grained password policies to OUs as you do with GPOs. Rather, you apply them to users and groups. http://technet.microsoft.com/en-us/library/cc770394(v=WS.10).aspx


4

That error is extremely clear, and I question how much time you have spent thinking about it. The core message reads: Unrecognized attribute 'targetFramework' So it's clearly a problem with this line in particular: <compilation debug="false" targetFramework="4.0"/> The last line of the error message makes it very obvious there is a discrepancy ...


3

This depends on what kind of network you're running. On a single machine (which seems may be your case) you can create a profile (non-administrator) and set everything up the way you want it there. Then log off, log on as an administrator, and copy that profile to the Default User profile. To copy, right click My Computer, and select properties. Go to ...


3

I am successfully running an ASP.NET MVC application on Ubuntu 8.04 LTS in a Rackspace Cloud Server. If you are planning on working with ASP.NET v2.0 and .NET 3.5 including LINQ, I suggest the following procedure, which has led to my own setup. I am still struggling with some HTTPS requests under Apache but with xsp it all works just like on a Windows ...


3

Yes, using tsdiscon from a command line: tsdiscon n where the n should be replaced with the session id. You can get the session number from query session Since you say you want to close all sessions on the local computer, I guess you will need to be careful about the order in which you do it (ie close your session last).


3

It's hard to tell from your post what you're looking for, but this might be it: Windows Management Instrumentation WMI in .NET EDIT Added link to WMI in .NET reference pages.


3

Set max_allowed_packet in your my.cnf MySQL configuration file See http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html for more information.


3

No database product, no matter how high you move up the chain, will let your share connections and transactions between threads concurently. You will always have to serialize access to a transaction/connection. You are asking for a non-sense requirement. One thread is going to commit what the other just rolled back? There are many products that support ...


3

You're saying that you have no SNMP access to the swtich, and want to run a script on the Windows PC to query what port on that switch you're on? There is no way to do that. The only thing that can tell you that level of info is the switch itself. SOL, sorry to say. Unless you have some other method of querying the switch, that is. If you don't have SNMP ...


3

Do your switches support CDP or LLDP? If so, you just have to capture the packets on the PC. Spanning tree has a port ID field as well, but its value might require further interpretation depending on the make and model of the switch. For example, LLDP says I'm plugged into port "g7". STP says it's 0x8007. If you don't want to do the packet dissection ...


3

Process monitor (www.sysinternals.com) will let you know if there is a file level permission issue and if the command line executable is really running under the user you expect it to. For spite, try a sql auth connection string vs the windows auth that you're using. That may help you narrow down permission issues if this is permission related.


3

There is no such thing as a "portable" version of Sql Server, as provided by Microsoft. There are "light" versions of Sql Server such as Sql Server Compact edition, but any "portable" version would have to be created by you. By "created by you" I mean: Extracting all the files from the installers Determining how/where they need to be deployed/registered ...


3

Open "SQL Server Configuration Manager" Expand the "SQL Server 2005 Network COnfiguration" tree Select "Protocols for MSSQLSERVER" Right click TCP/IP Open the "IP Addresses" tab Under "IPAll", change the value for "TCP Port" from 1433 to 1966


3

After working with MS for a week, we've worked out why this happens. Essentially, the application is not failing over because it needs to be sure that the database has failed over - and the sql connection is timing out before the connection has determined that the db has failed over. The process to confirm that the database has failed over (with all the ...


3

If your IIS and SQL servers are in a domain together, create a domain user to serve as the identity of the app. Set the app pool identity to that user and add it as a db user. Also make sure the user has access to all the application files.


3

If the servers are part of an Active Directory domain then you can create a .msi installer for your service and deploy it through Active Directory. See this question for the steps to do this.



Only top voted, non community-wiki answers of a minimum length are eligible