• Why GPO only affects certain users?

    Hello, My DC with AD is running off a w2k server box, i have 10 users in an OU. I linked a GPO to that OU and it works on some users in the OU and not on others. All users are running winxp sp2. any ideas?

    Projectpete0 pointsBadges:
  • Modify Backup SQL QUERY

    Hi I want to modify the query BACKUP LOG PRD TO DISK = 'S:BackupLogsPRDbklog.BAK' to include the timestamp at the filename. for example BACKUP LOG PRD TO DISK = 'S:BackupLogsPRDbklog<timestamp>.BAK So how could i append the timestamp to the filename? Thanks

    Knowlegde0 pointsBadges:
  • ADMT Migration Blues

    Hi, I really hope someone can shed some light on a problem we've been having as after a 86 hour week my brain just isn't thinking straight anymore. For the purposes of this post I will refer to the domains as DOMAIN1 (NT) and DOMAIN2 (Child domain in 2003 Forest) We are in the process of migrating...

    Papalazarou0 pointsBadges:
  • BITS & Automatic Update Issues

    Dear All, Can you help please? Automatic Updates problem. I have recentl upgraded to the new update Microsoft Automatic Update version and ever since have been having problems. I have been able in the interim download the necessary critical updates etc directly from the Microsoft site, so the good...

    Jessica0 pointsBadges:
  • Group policies are not effective in WIN2K

    Defined Group policies in WIN2K domain controller. When user login into domain, the policies are not downloaded into clients system. Eg. Remote registry is disabled in domain controller. But in clients place, we monitored that the remote registry is automatic. Pls help

    Varadhu0 pointsBadges:
  • No domain controller available

    We have 4 locations and are running Windows 2000 Server. Each site has at least one domain controller. About once a month or so, one or two users at one site receives an error when trying to log on that there is no domain controller available or their account was not found. I have to log in to the...

    PTidwell0 pointsBadges:
  • Trying to solve ORA-00980: synonym translation is no longer valid

    I ran the catalog.sql script on my Enterprise DB in preparation for exporting a schema from my Oracle 9i version 9.2.0.1.0 Enterprise DB with an Enterprise Manager Server and Intelligent Agent to an Oracle 9i version 9.0.1.1.0 Personal Edition DB(Each DB running on separate PCs in my LAN). I ran...

    Aascotty0 pointsBadges:
  • Generating Random numbers in SQL

    I HAVE a problem How can i use command or functios to combine numbers For example If k = 6 and n = 3 The command should return (as B1,B2,B3) 1,2,3 1,2,4 1,3,4 1,3,5 1,3,6 1,4,5 1,4,6 1,5,6 2,3,4 2,3,5 2,3,6 2,4,5 2,4,6 2,5,6 3,4,5 3,4,6 3,5,6 4,5,6 For all n of k numbers Thanks

    Ajibola110 pointsBadges:
  • SQL Server worst practices

    Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here:...

    Nbellistri0 pointsBadges:
  • COMPARING CELLS IN SQL

    My database KoloID FIRST SECOND THIRD FORTH 01 4 8 6 10 02 10 8 12 9 03 4 5 6 9 04 3 6 6 9 ETC How can I use select to return P,P1, P2,... P10 ETC P = relationship between values of the last koloId(04) and koloID(3) = Number of cell with the sam values = 2 (6 and 9) P1 = relationship between values...

    Ajibola110 pointsBadges:
  • COUNT IN DATABASE

    My database NumberId jb1 jb2 jb3 jb4 jb5 jb6 01 1 2 0 5 7 9 02 2 2 2 1 0 9 03 0 2 1 6 6 7 select( cast(case when jb1 = 1 then '1' else '0' end as int)+ cast(case when jb2 = 1 then '1' else '0' end as int)+ cast(case when jb3 = 1 then '1' else '0' end as int)+ cast(case when jb4 = 1 then '1' else...

    Ajibola110 pointsBadges:
  • Upgrade to SQL Server 2005 sooner or later?

    Hello, I'm the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic. Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization's plans? 58%...

    RobynLorusso230 pointsBadges:
  • import exchange mail log into SQL 2000 personal edition

    i am trying to import the exchange log (in servername.log) to sql2000 for filtering purposes but keep on bumping into error "column delimiter not found". please help

    Faisalsusanto0 pointsBadges:
  • SQL backups failing

    All of a sudden some of our SQL backups are failing with this error: Operating system error 64(The specified network name is no longer available.). These backups are being written to a different server, then backed up to disk. To rule out DNS issues, I changed the failing ones to use IP. Still...

    BRNeyes0 pointsBadges:
  • DB2 function

    Hi! I am using following expression in report filter. It gives parsing error. Presentation Layer].[Recent Claims].[Specific Service Date YMD] BETWEEN (?Parameter1?) AND ((?Parameter1?) - 200 DAYS). The database is DB2. Please let me know what is wrong? Thanks a lot,

    Meenac0 pointsBadges:
  • Number Crunching Machines

    I just started at a new workplace and have been presented with a group of servers running software called Calcserve. I'm not entirely sure what they actually do but it is some sort of number crunching for various trust funds etc. What concerns me though is that I have worked on AS400's now for...

    Neilm1m0 pointsBadges:
  • exception join

    SELECT GRPID, MEMBER.PLNCD, MBIDT, MBSEX FROM MMEMBER EXCEPTION JOIN GPLANMAS ON MMEMBER.PLNCD = GPLANMAS.PLNCD This is a query used in showcase tool. It is looking for members who are noted in the member file with an invalid plan code. The current query produces 18 members with either invalid plan...

    Meenac0 pointsBadges:
  • ASP.NET performance degradation

    I'm running ASP.NET 1.1 on a Win2k server, application is written in VB.NET, with SQL server 2000 db on another box. ASP.NET application has very large pages with very complex data filled controls, but is only used on an Intranet by a small number of people. When users initially login, it performs...

    Infrastructure328080 pointsBadges:
  • calculation at database level

    Hi! I will really appreciate help. Please take a look at few rows of one table . MBRNO Readmit READMIT DATE READMIT Readmit Seq. NO DISCHARGE date NO. of days 121 1 20030101 20030105 5 2 20030105 20030115 10 3 20030202 20030218 3 4 20030218 20020220 0 The measure is count of cases. I do not want to...

    Meenac0 pointsBadges:
  • SQL Clustering

    SQL Server 2000 As far as performance tuning, where can I find statistics or could you offer your opinion in the following scenario. Which offers better performance, running One server in Active mode and another in inactive mode, each with four processors or Running both servers in active mode,...

    Krismop0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following