Search results for query: *

I looked at thread already and it points to RASMAN and not the Remote Desktop Services service. I also compared all the registry entries to a working computer and they were an exact match. I have also updated all of the dll's associated with the remote desktop services. (termsrv.dll) This...

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...

worked like a charm. PS proper input is always important.

I like that way of approaching it however declare @date_exp datetime = 2013-08-15 SELECT DateAdd(Day, -1, DateAdd(Year, 1 + DateDiff(Year, 0, @date_exp), 0)) 'Last Day of Current Year' Returns a value of 1905-12-31 I would think it should return a value of 2013-12-31 Thanks

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 -...

Check to make sure the printers on those servers are set to be published in the directory

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...

Is it possiable to add an Avg to this. id | Name | Status | Score 1 John 5 100 2 John 5 300 3 Susan 2 500 4 Susan 5 100 Grouped by Name I want the avergae score when status = 5?? Thanks in advnace

Worked like a charm... Thanks...

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...

If its a SBS server set up Remote Web Workplace. Get a firewall at that Site ASAP. You can also look at the Netgear FVS336G that lets them VPN in over SSL.

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?

Makes total sense. I also have Standard Version so scheduling will not be an issue. Am i creating my own SP on the Database or can i just call the SP_SEND_DBMAIL in my scheduling. Thanks Nick

SQL Version 11.0.2100.60 (64 bit) - SQL2012.