Search results for query: *

I have an issue with a Windows 7 SP1 where all of sudden I can't start the Remote Desktop Services. When I try to manually start it I get a "Error 126: The specified Module could not be found" I have run SFC / Scannow to check for any missing or corrupt files. (Passed 100%) I have run SCAN...

I have two fields mytable.approval_date mytable.approval_exp_date all approvals expire on 12/31 of year they were approved. how can I write a query to update the mytable.approval_exp_date. ie. Approval = 2/1/2014 approval_exp_date = 12/31/2014 Any help would be great. Thanks Nick

I already have SQL2012 installed and working perfectly. However i want to start working SSRS. Is it possible to install this without having to re-install off of SQL. I remember reading somewhere that it had to be installed at the same time as the sql install. Can anyone please clarify this...

I have a bunch of workstations that have the windows 7 coa but have XP currently loaded on them. Is there an upgrade path or do i need to do a complete re-install? Workstations came with window 7 coa but were downgraded to xp. Thanks in advance. Nick

i have a 2008R2 server that backsup to a network location and after a few days of running fine the backup fails. It says there is not enough server storage to process the command. If i run the backup job manually it fails yet again. If reboot the 2003 server (backup location) the backup runs...

I have a server that i am trying to do a full backup of and its telling me i have unsupported partitions. I checked the partitions and one of the partitions is fat32 which is stopping the full backup from running. Drive G: is the culprit. In Disk Manager here is what i show: C: - Simple -...

I have a domain with 2 sites. Site 1 has 2 Server 2003 DCs and 1 2008 DC Site 2 has 1 2008 DC I lost one of my server 2003 DCs due a failure and can not get the server back online to do a dcpromo to demote the server. I know i need to do a metadata clean up to remove the dead DC from the...

I put into a place a GPO which would re-route the users my-docs to a server location. I had major issues with that server as i can only boot into SafeMode at this point. I need to change the location of that GPO to a working server. What is the proper way to do this? I don't want to screw...

Below is my table structure after joinning two tables in an SQL View. How the view is already grouped by name but i want to add a column showing how many status '5' rows there are for each group. I cannot figure out how to do this. I have to be missing something. I know it has be in the...

I need to be able to do full backups every night of my data partition. I have another server that has a lot of free storage running on a RAID 1 volume. What i want to do is the following but wanted to know if this is a bad idea. I need to be able to keep at least 1 weeks worth of backups. I...

I am using the @query Paramater in sp_send_dbmail and for reason i can't use a variable in my where clause set @Query = 'SELECT * FROM Email_Log.dbo.Email_Log Where ID = (''@Q_ID'')' its got to be syntax... Any ideas?

I need my SQL server to send an email based on certian criteria in a table is met. i.e. Sales Price >= 200000 then send email. I plan on adding a trigger to my table to insert some data into a Email_Notification table where it iwll set 1 field (Status) with a Bit datatype to a '0' indicating...

I am going to be migrating data from an old 2k server to a new 2008 server. I need to make sure all fo the shares and permissions are carried over as well. Will a simple Backup and Restore work. I am looking at about approx 130 GIG of data under mutiple shares. The current Data is stored on...

I have two people working in a remote office using IP Phones. They are connected to our office via two Netgear VPN routers. Everything has been working fine for a long time. Over the past few weeks her phones have been dropping and then re-connect in about 30 secs. I have seen her phones...

We are getting a lot of calls comming in from our sales phone number that need to be directed to customer service (External toll free number). I would like our sales people to be able to transer to either a DN or Hunt Group instead of them remembering the external number. Is there a way to do...

I am going to order a dell server that will be running sql2008 express. Can anyone recomend any server/hardware configs for the server. I am asumming i want to put the database files on a seperate drive and have some sort of redudancy. I am looking for some expert advise here. Thanks Nick

I need to move a C# Console Project to a network share and i am not sure how to do so. I thought of just copying the source folder and moving it to a network share would do it but my changes do not take effect on the network share. Any advice / pointers would be great. I tried to google it...

I have created a C# program that pulls data from a Database and dumps it down to XML which is then uploaded to a 3rd party. I just ran into a snag that i am sure is an easy fix. My query will return mutiple rows and in one section of my code i need to pull the data from all of the rows and...

I am a newbie trying to work on project. I do not have any C# experience but do have some VB experience. I have a table that Has two Columns. Employee_ID, Last_Name I need to find a way to pull out the Last_Name and use it further down in my code to place the value into a XML file. The XML...

This forum seems a bit more advanced for what i am looking to do but i figured i would give it a shot. I need to create an xml file to submit data to a company. they are not providing any help on how to create the xml. they just gave us a sample xml file and an xsd file. The data will be...