Search results for query: *

Hello all, I need to setup a temporary Call Manager Express system while the Call Manager system is being built. I have the the CME system just about complete but reached and area that is really kicking my butt. I understand Call Manager Call Flow but with CME I am just not grasping it. In CM I...

I think this may be a silly question that came about from configuring a switch for Auto QOS for ip cameras. The debate was, should the recording server switch ports be programmed with "auto qos video ip-camera"? What does this have to do with CM? Well, I was under the impression that CM...

Hello, is there a way to query a sql database by the amount of characters? I am trying to find account numbers longer than 12 characters. Thanks "I hear and I forget. I see and I remember. I do and I understand." - Confucius (551 BC - 479)

I am trying to setup a VG202 as an MGCP gateway with CallManager. I cannot get the FXS ports to register with the CM. When I run show ccm-manager on the gateway it says Registered but the History Error Log shows: voice-port 1/0 no shut voice-port 1/0 signal loopstart It seems like the CM is...

I am trying to setup a VG202 as an MGCP gateway with CallManager. I cannot get the FXS ports to register with the CM. When I run show ccm-manager it says Registered but the History Error Log shows: voice-port 1/0 no shut voice-port 1/0 signal loopstart It seems like the CM istrying to no shut...

Hello all, I need to see if something I have been tasked with is possible and if it is any help on how to code it would be much appreciated. Here goes, Two servers SERVER-A and SERVER-B. SERVER-A HAS DATABASE-A with TABLE-A with COLUMNS 1 2 3. SERVER-B has the exact same scenerio DATABASE-B...

Hello, I need help converting a column that is set up as an integer to date time. My current query - SELECT dateTimeConnect FROM dbo.CallDetailRecord - returns 1284149324. I need to convert this number into datetime for some custom reporting. This conversion needs to be part of this query as...

Hello all, Can someone please help me with either a link or sample configuration for a 3 site VPN configuration. I am familiar with a site to site configuration but have never programmed this for 3 locations. In other words I have a customer that needs to set up a site to site VPN to two of his...

Hi All, I am having a problem with an ASA 5505 setup to as an Easy VPN Server. All works well except that the device acts as a DHCP server for the local lan and issues ip addrsses in the 192.168.1.0 network (default). The problem I am having is some vpn users home routers issue address to their...

Here is a stupid question, why is there no Config T option on a brand new Aironet 1300. I starts up OK, I enter Enable OK, it asks for a password I enter Cisco OK, I type Configure Terminal it says Configure is an invalid input. In the list of available commands configure terminal is not there...

SELECT ID, ACTIVATE, DEACTIVATE, CAST(ACTIVATE AS VARCHAR) AS [Activate Date], CAST(DEACTIVATE AS VARCHAR) AS [Deactivate Date] FROM VENDOR In the above statement how do you keep the original ACTIVATE and DEACTIVATE from being returned in the result set? In other words, I only want to see the...

Hello all, I lost my SQL server 2000 Disks, does anyone know where I can download this media? I have the license, SP3a and 4 and Reporting Services but no SQL installation disks. I need to do some testing in a virtual lab and am limited on time so it would be great if I can find some place to...

Hello, I have a couple of 3529 switches I decided to use in a temp office, they both have 2 gigabit ethernet GBIC slots and I cannot get any of them to work. When I plug in the 1000 BaseT GBIC's the switches recoognize them but I cannot get these two ports to come up. when I run the No Shutdown...

Hello, Can someone please help me with a small issue I am having, I need to delete all the information in an excel spreadsheet except for the first row which contains column headings. Thanks a bunch for your time. "I hear and I forget. I see and I remember. I do and I understand." - Confucius...

Hello all, I have the following script which gets User info from an Excel spreadsheet and creates the users in Active Directory. Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open ("D:\Scripts\New_Users.xls") intRow = 2 Do Until objExcel.Cells...

I recently got some great help with the xp_fileexist sp, in a test lab I tried to use this sp to see if a file exists on a network share not on a local disk and it would not work. This is the code, which I recevied from gmmastros (thanks again) that works great on the local machine. Declare...

Hello everyone, I have project that loads data from a flat file into an sql table and performs mutipule tasks with this imported data. This project works great, but now I have to check for the exixtance of an other file before any other part of this project executes. This other file is a text...

Hello all again, I have to start off by saying I just installed SQL 2005 and am not that versed with it. With that said I have to write a job that imports data from a flat file but only when a "trigger" file is present. This trigger file is only there when the flat file has been updated. If the...

Hello all, I have quick question about a problem I just ran into. I have a tabel with the following columns, FirstName LastName EmployeeID FirstNameInitial Is there an sql command that I can run to populate the FirstNameInitial column with just the first letter of the FirstName column. I have...

How dificult is it to send the results of a query via email? I run a simple SELECT stored procedure weekly and now need to send these results via email to one recepiant. I have access to both SQL Server 2000 and 2005. I am not using Exchange Server and do not have Outlook installed on any of...