When the below restore script  was executed ,it's trying to restore databases that already in non recovery mode (always on setup) I try to restore all databases  in no recovery mode but not databases which has already been set up for  always on . want to exclude restore with always on please help

RESTORE HEADERONLY FROM DISK = 'C:\backup\test.bak'

USE [master]
GO
/****** Object:  StoredProcedure [dbo].[sp_RestoreFromAllFilesInDirectory]    Script Date: 16/07/2017 15:22:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[sp_RestoreFromAllFilesInDirectory]
@SourceDirBackupFiles nvarchar(200), @DestDirDbFiles
nvarchar(200),@DestDirLogFiles nvarchar(200)
AS
--Originally written by Tibor Karaszi 2004. Use at own risk.
--Restores from all files in a certain directory. Assumes that:
--  There's only one backup on each backup device.
--  Each database uses only two database files and the mdf file
---is returned first from the RESTORE FILELISTONLY command.
--Sample execution:
-- EXEC sp_RestoreFromAllFilesInDirectory 'C:\Mybakfiles\',
----'D:\Mydatabasesdirectory\' ,’C:\MylogDirectory\’
SET NOCOUNT ON

--Table to hold each backup file name in
CREATE TABLE #files(fname varchar(200),depth int, file_ int)
INSERT #files
EXECUTE master.dbo.xp_dirtree @SourceDirBackupFiles, 1, 1

--Table to hold the result from RESTORE HEADERONLY. Needed to get
---the database name out from
CREATE TABLE #bdev(
 BackupName …

In Excel 2013, I have an excel file with a macro that contains this code:

Function UserNameOffice() As String
    UserNameOffice = Application.UserName
End Function

And in cell A1 i have this code:
=UserNameOffice()

The first time I run the file, and receive the "SECURITY WARNING Macros have been disabled" prompt and click the "Enable content" button, the field updates properly and displays the correct name in Office. However, every time the file is opened after this the field will not update. I have to manually go into the cell's value, and hit enter on it to get it to update.

If I go into the Trust Center / Trusted Documents / checkbox Disable Trusted Documents - the code will update the field properly every time you click the "Enable Content".  Or if I Click the Clear button to remove all trusted documents, it will then work the first time opened only. So it seems like there is a bug within Trusted Documents causing this feature not to work.

Has anyone experienced this before or know a work around? This is not a problem in Excel 2016.
Book1.xls

I've had it about 5 years an all sudden when I turned it on it showed the Hisense logo but it wI'll go to a black screen an have no picture. I can hear a sound of the channel though

Hi,
When i go to another VLAN with my laptop, It will not get the connection from network or we can say it will take some time to get IP from new VLAN from old VLAN. If i connect the laptop from Wireless it shows connected.
I want the suggestions that i would be able to connect on diffrent VLANs with my laptop and with my netwrok.

Hi All,
I have a doc library with many folders.  
I created a view where Checked out to = [Me]
If I go to the folder and choose the checked out view it works
If I am in the library and not in the folder I don't see my checked out file in a folder

How do I set up the view at the top level of the library and it spans all folders?
Also how do I see ALL checked out files regardless of who checked them out and where within the library?

TIA,
Joe

hi experts my code is like that check on table1 if textbox1.Text exist if yes go to table2 and check if textbox1.text exist and if textbox2.Text exist if they exist open the form if not insert them and open the form and if textbox1.text exist and textbox2.text doesn't exist close form

i wrote this :

MySqlConnection con = new MySqlConnection(connectionString);
            i = 0;
            con.Open();
            MySqlCommand cmd = con.CreateCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "select * from informat where u_ser = '" + metroTextBox2.Text + "' ";
            cmd.ExecuteNonQuery();
            DataTable dt = new DataTable();
            MySqlDataAdapter da = new MySqlDataAdapter(cmd);
            da.Fill(dt);
            i = dt.Rows.Count;
            int userial = metroTextBox2.Text.Length;
            if (userial >= 5 || metroTextBox2.Text == null)
            {

                MySqlConnection conet = new MySqlConnection(connectionString);
                conet.Open();
                MySqlCommand cmsd = conet.CreateCommand();
                cmsd.CommandType = CommandType.Text;
                cmsd.CommandText = "select * from alred  where u_ser = '" + metroTextBox2.Text + "'and u_ip =  '" + textBox1.Text + "'";
                cmsd.ExecuteNonQuery();
                DataTable ddts = new DataTable();
                MySqlDataAdapter ddas = new MySqlDataAdapter(cmsd);
                ddas.Fill(ddts);

         

Select all Open in new window

…

we are moving to o365 and I need your recommendations-
we head quarters have emails park at network soulutions
we have couple of stelite offices and most of them have emails hosted on different go daddy sites
Couple of them are on exchane servers too
We gave this project to third party vendor and hey are doing for us
What would be best strategy? we dont want one day cut off
we want one by one
one site cutoff and help users
2nd site cutoff and help users
so that process goes smoothly
any suggesstions?
I'm looking for besst traing materials for end users so that I can prepare document for them. I would like to include all functionalities of office 365 2016 ncluding skype for business.

I am working on a project in the middle of nowhere and have several offices over a 25 mile radius. This project i am working on has 7 construction companies all supplying resource to the project. Now each of these companies supplies IT equipment to each of their staff and is on on their own domain, so we have

7 companies supplying their own staff with domain locked computers.

What i want is to set up some dedicated lines to each of the companies and arrange with them a link from there corporate environment to the project environment to help facilitate computer updates without having to go to a corporate office. One company is using DA which is not great.

Does anyone know the best way this can be achieved and have either instructions or links to instructions on setting this up?

• We have access to our networks, routers etc

• The project is not a domain

• 7 companies are employed on this project

• Each company has their own staff and BYOD on their domain

Finally

• I need to set up links to each of these companies so that computer updates and installs via SCCM can be installed

Thanks in Advance

John

Im using a dental program open dental i am trying to you use the eservices when i go to install i get the error message . failed upgrading to the econnector service.. requested registry access not allowed..  logged in as admin on the server ... i am running 2012 server essentials..  I tried installing manually I get this error..... application attemted to perform an operation not allowed by the security policy to grant this application permission contact system admin or use the .NET framework config tool

hey ,

the port that has the sfp SR does not come up , i have tried to do a shutdown no shodwon and still does not come , when i do shutdown command the port does not go for orange color .


i am confused !

BR

I have a SFTP server in DMZ (D-SFTPS) and a SFTP server in LAN (L-SFTPS).  The idea is that any SFTP traffic between WAN and LAN has to go through D-SFTPS and L-SFTPS.  What is the best practice to enable communication between D-SFTPS and L-SFTPS when it only involves sftp between internal server and external server?