View Complete Post
i always changes in database while developing application and when i goto client again i have manually changes in database.
is it possible to changes though script i.e if field not exist in table it will add.
I have two processes that are both listening to UDP packets and can run on the same PC. One process binds a socket to one NIC address with port 18246. The other process has two Socket objects, one for sending on port 18246 and one for listening
on port 18246. Both of these sockets are created, have the SO_REUSEADDR socket option set. Bind is called for a single IP Endpoint for a common local NIC address, but a different one than used by the above app.
Under Windows XP and server 2003, both processes can bind regardless of order of startup.
Under Windows 7, if the process with only one socket starts first, the second process fails with WSAEACCES 10013 error with the second socket bind.
I wrote a sample C# app with the following method that fails when running under Windows 7 x86 and x64. The above failure occurs when the sockets are in separate processes, but a single process using the same socket interaction also fails. The
below method is called with two IPV4 addresses that are assigned to local Network adapters on the PC.
I received last week a notice about the expiration period of SQL Server 2008 R2. I honestly got surprised considering that I installed the Express Edition.
This week, I noticed an article announcing the coming out of SQL Server 2008 SP2. This really caught my attention.
A few questions:
1- Is R2 a release candidate version of SQL Server 2008 Express?
2- If so, how can I uninstall it from the moment SP2 is available for download. Must I use the original setup program I used for install?
3- Actually I'm using SQL Server 2008 R2 Express Edition with Advanced Services. What is the equivalent for the SP2 version. Where can I find it for download?
Thanks for helping,
can any one tell me the main difference between sql server 2005 and 2008 in interview point of view?
One of my customer db there is one maintenance plan(full backup / Transaction log backup ) schedule time for the full backup is 11:00:00 PM daily and for transaction log backup 12.30 pm Sunday to Friday ,I
checked the job created by maintenance plan there also schedule time is same but when i check the history of the job it shows it happened at 7:00:00 pm every day. why there is time difference ?
Product version is 8.00.2055(SP4)
i checked the MSDB.dbo.sysjobschedules table and the next_run_date is not updated properly,it is showing yesterday 11:00:00 pm
please help me to resolve this issue